If is not null, shade red

[Kirstie Adam]

Dear All,

I know how to do this in access, but not excel.
I just want to write code / formula that says if one cell is not blank, the
cell is shaded red.

Can anyone help?

Kirstie Adam

 

[Norman Harker]

Hi Kirstie!

Try:

Format > Conditional Formatting

Example:
Select B6
Format > Conditional Formatting
Formula Is:
=ISBLANK(B6)=FALSE
Click on Format and choose your format
OK
OK

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
Public Holidays Friday: Belgium (Flemish Community Holiday and
Guldensporenslag); France (La Fete de la Magdalene); International
(World Population Day); Italy (St. Rosalia Day); Mongolia (Revolution
Day).
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.