Forum Discussion
Excel Conditional Formatting
When the condition is met in a cell I need the entire row to format. Any ideas?
Create a Rule for each condition (i.e =Completed, = Pending etc..)
I can make the rules. What i can't seem to make happen is to highlight the entire row based on one cell within it.
You have to select the whole table before you create the rule. Attached is an example.