how to check for ANY text when conditional formatting?
 

I just want to conditionally format the cell if there is ANYTHING written in
the cell. Can't figure it out!

how to check for ANY text when conditional formatting?
 

Hi Heather

Try
=NOT(ISBLANK(A1))

--
Regards

Roger Govier


"Heather" wrote in message
...
I just want to conditionally format the cell if there is ANYTHING
written in
the cell. Can't figure it out!

how to check for ANY text when conditional formatting?
 

Thank you soooo much!! I've been working for ages on this!

"Heather" wrote:

I just want to conditionally format the cell if there is ANYTHING written in
the cell. Can't figure it out!

how to check for ANY text when conditional formatting?
 

Hi Heather

Your very welcome. Thanks for the feedback.
There are many days when I can stare at the screen and not see the
obvious!!!

--
Regards

Roger Govier


"Heather" wrote in message
...
Thank you soooo much!! I've been working for ages on this!

"Heather" wrote:

I just want to conditionally format the cell if there is ANYTHING
written in
the cell. Can't figure it out!

how to check for ANY text when conditional formatting?
 

Hi Roger,
That does work but I need to use it in a cell that has a formula in it.
Unfortunately it seems to see the formula as an entry. Any suggestions?

Leeney

"Roger Govier" wrote:

Hi Heather

Try
=NOT(ISBLANK(A1))

--
Regards

Roger Govier


"Heather" wrote in message
...
I just want to conditionally format the cell if there is ANYTHING
written in
the cell. Can't figure it out!