H
Heather
I just want to conditionally format the cell if there is ANYTHING written in
the cell. Can't figure it out!
the cell. Can't figure it out!
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
R
Roger Govier
Hi Heather
Try
=NOT(ISBLANK(A1))
Try
=NOT(ISBLANK(A1))
H
Heather
Thank you soooo much!! I've been working for ages on this!
R
Roger Govier
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!!!
Your very welcome. Thanks for the feedback.
There are many days when I can stare at the screen and not see the
obvious!!!
L
Leeney
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
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