ExcelBanter - Conditional Formatting

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

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

- - Conditional Formatting (https://www.excelbanter.com/excel-worksheet-functions/35904-conditional-formatting.html)

Dee

Conditional Formatting

I want to apply conditional formatting to a cell and I want it to change the
colour of the cell to blue if the cell is not blank. Would I use the IF
function. If yes, how would I write the formula to colour the cell if the
cell is not blank. I'm not sure how to indicate "not blank" in the formula. I
am using Excel 2003

Thanks very much for your help.

Best regards,

Dee

JE McGimpsey

One way:

CF1: Formula is =NOT(ISBLANK(A1))
Format1: patterns/blue

In article ,
Dee wrote:

I want to apply conditional formatting to a cell and I want it to change the
colour of the cell to blue if the cell is not blank. Would I use the IF
function. If yes, how would I write the formula to colour the cell if the
cell is not blank. I'm not sure how to indicate "not blank" in the formula. I
am using Excel 2003

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