I am looking to format 500+ rows of data and essentially, G5-K5 (in every row) needs to be highlighted a light color (any color) if J5 equals "Regular".
This same condition will exist in every row, so it should be simple - but I am not an excel master by any means. I just don't think it's necessary to create 500+ conditions for each row!
That is actually pretty simple.
- You right click one of the cells to do the formatting(one with
regular for example) and select Conditional Formatting on the menu.
- Then you make sure the Range is the cell you right clicked, select
"The text is exactly" in the list and type "Regular in the field
- Select the color under that field and press the blue button.
- After that you just need to press the paint format tool(the paint
roll) and drag all the cells you want to have the same
behaviour(probably the entire column of the right clicked cell).