conditional formatting

C

Carrie

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.
 
G

Gord Dibben

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
 
Top