View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Paperback Writer Paperback Writer is offline
external usenet poster
 
Posts: 23
Default Conditional Formating IS: Help With ANY VALUE

I am using conditional formatting in regards to a form that needs to be
filled out. As the user fills out the required fields, the fields change
from YELLOW to WHITE.

Trouble I am having is alpha-numerics. I need an "IS" statement that allows
me to change the cell from YELLOW to WHITE whenever ANY VALUE is placed into
the particular cell.

I need something like: =ISANYVALUE(A1)

THANK YOU