| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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! |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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! |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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! |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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! |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Conditional formatting of text in a shared workbook. | Excel Worksheet Functions | |||
| Conflicting Conditional Formatting | Excel Discussion (Misc queries) | |||
| conditional formatting on specific text in cells | Excel Discussion (Misc queries) | |||
| Conditional formatting based on text | Excel Worksheet Functions | |||
| Conditional Formatting in Excel Help Please..... | Excel Discussion (Misc queries) | |||
Linear Mode
