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.
regular for example) and select Conditional Formatting on the menu.