financial excel course london - 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