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?

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