Excel Query

[PCDave]

Is there a way of saying if cell C* = No then colour Cell A*, B* and C* using conditional formating (Where * = row number?)

 

[PMKeates]

Yup. Highlight the cells you want to highlight on the first row - Format > Conditional Formatting. Select "Formula Is" and enter: =$C*="No", where * is the first row number. Set the formats you would like to have and then apply. Then, copy and paste this formatting to all the rows you want it to work on.