ExcelBanter - IF funtion to result in cell colouring

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - IF funtion to result in cell colouring (https://www.excelbanter.com/excel-worksheet-functions/215910-if-funtion-result-cell-colouring.html)

Peta

IF funtion to result in cell colouring

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

Eduardo

IF funtion to result in cell colouring

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, A15, red etc

"Peta" wrote:

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

All times are GMT +1. The time now is 01:11 AM.