Before I nuked my original blog one of my most popular posts was a step by step guide to using a rule to apply conditional formatting to an entire row if a condition in one cell is met. I thought it’d be good to re-post something similar here.
The screenshots below are taken from Excel for Mac, but the same steps apply in the Windows versions. It just looks a little different.
=tells Excel that this is a formula
$Ctells it that the data it will be evaluating is always in column C by using the dollar sign
4tells it that the first row of the evaluation is on row 4 of the sheet
="Bad"is the condition it will check.
And there you have it. If my explanation isn’t the clearest, hopefully the screenshots give you enough to go on. Pop any questions into the comments!