View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
T. Valko T. Valko is offline
external usenet poster
 
Posts: 15,768
Default conditional formatting

Try using:

Conditional Formatting
Formula Is: =A1=""

Biff

"Carrie" wrote in message
...
Hi - I would like to use a conditional format on a drop down list (A2) so
that if the cell to the left of it (A1) is blank then format drop down
list
to font white. BUT there is a formula in the cell to the left (A1) I want
to
use and even when returns a blank answer the conditional format does not
recognise this as blank. I did try =ISBLANK(A1) but can't be putting it in
right as doesn't work.
Please help.
Many Thanks.
--
Carrie