1 min readfrom Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community

Is there a way to highlight a cell that is a crossover if appears in both a row and a columns?

Our take

If you want to highlight cells that represent the crossover of initials in both rows and columns, there’s an effective method to achieve this. By utilizing conditional formatting in your spreadsheet, you can create a visual indicator for the intersections of initials across your dataset. This approach not only enhances clarity but also makes it easier to identify key overlaps at a glance. Explore the steps to implement this highlighting technique and transform your data management experience.

If I have initials of names on columns across the top of a sheet, and a list of all initials on a row down the left side, is there a way to highlight where they crossover?

https://ibb.co/tpWm02yJ

submitted by /u/Separate-Sector5205
[link] [comments]

Read on the original site

Open the publisher's page for the full experience

View original article

Tagged with

#row zero#rows.com#Excel compatibility#Excel alternatives for data analysis#Excel alternatives#highlight#cell#crossover#initials#names#columns#sheet#row#Excel#list#top#side#intersection#submitted#data