conditional formatting

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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

For starters, A1 is above A2, not left of A2. There is nothing left of column A
so what cell do you want to trigger the CF?

For seconds a cell with a formula cannot be blank so the ISBLANK function will
not work.

I will assume you want A1 as the trigger cell.

Select A2 and CF>Formula is: =A1=""

Format to white font.


Gord Dibben MS Excel MVP
 
Back
Top