ExcelBanter - Change colour in cell

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

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

- - Change colour in cell (https://www.excelbanter.com/excel-worksheet-functions/163834-change-colour-cell.html)

Haris

Change colour in cell

Hello guys,

i remember i did it for an assignment in high school with old excels,
however i can't find the formula for changing the colour of a cell , if
certain condition are met... Something similar to the 'IF' however one
condition to be to change a cell to red colour...

thanks in advance

Niek Otten

Change colour in cell

FormatConditional formatting

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Haris" wrote in message ...
| Hello guys,
|
| i remember i did it for an assignment in high school with old excels,
| however i can't find the formula for changing the colour of a cell , if
| certain condition are met... Something similar to the 'IF' however one
| condition to be to change a cell to red colour...
|
| thanks in advance

All times are GMT +1. The time now is 10:00 PM.