Thread: how to check for ANY text when conditional formatting?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Roger Govier Roger Govier is offline
external usenet poster
  
Posts: 2,886
Default 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!




Reply With QuoteReply With Quote