P Peta Jan 9, 2009 #1 Need help to asign colours to cells using muliple IF function. Can anyone help with what code to use please?
Need help to asign colours to cells using muliple IF function. Can anyone help with what code to use please?
E Eduardo Jan 9, 2009 #2 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
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
