Katie has attended:
Excel Intermediate course
Conditional formatting
I would really like to know how I would apply a conditional format to a row of data - i.e. if I have a list of values (revenue and costs) and the amount in the total column is 0 or less - how would I get the entire row to go red?
RE: conditional formatting
Hi Katie,
for this example, let's say your total column is column E
first of all, in your total column, click format > conditional formatting then as the criteria of 'cell value is' type in <=0 and change the format to how you would like it
for the rest of your columns, highlight them all, go format > conditional formatting, change 'cell value is' to 'formula is'
then type =IF($E1<=0,TRUE,FALSE)
change the format to how you want it again, then you're sorted!!
Paul
