IF funtion to result in cell colouring

P

Peta

Need help to asign colours to cells using muliple IF function. Can anyone
help with what code to use please?
 
E

Eduardo

Hi Peta,
Use conditional formating, highlight the range you want to apply the
different colours and then in conditional formating with formulas use the
condition you want to apply. i.e. =A1 >1 colour yellow, A1>5, red etc
 
Top