View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Carrie Carrie is offline
external usenet poster
 
Posts: 68
Default conditional formatting

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