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

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

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 CFFormula is: =A1=""

Format to white font.


Gord Dibben MS Excel MVP

On Tue, 1 May 2007 14:09:00 -0700, Carrie
wrote:

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.

Thank you so much that worked - sorry for confusion of cells :-)
--
Carrie


"Gord Dibben" wrote:

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 CFFormula is: =A1=""

Format to white font.


Gord Dibben MS Excel MVP

On Tue, 1 May 2007 14:09:00 -0700, Carrie
wrote:

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.