Conditional formatting

[Sandy]

Hi,
Is the following possible with conditional formatting:

If cell A1 is blank then the normal format for A2 (which has a list entry
drop-down box) is a dark blue background and contains no text..
However if cell A1 contains the text "Miss" then cell A2 should have a
background of light yellow, which indicates text entry required.

Here's the bit
When the text has been entered in A2 the cell background (of A2) should
revert to dark blue with the text white. Can it be done??

Sandy

 

[Beege]

Hi,
Is the following possible with conditional formatting:

If cell A1 is blank then the normal format for A2 (which has a list entry
drop-down box) is a dark blue background and contains no text..
However if cell A1 contains the text "Miss" then cell A2 should have a
background of light yellow, which indicates text entry required.

Here's the bit
When the text has been entered in A2 the cell background (of A2) should
revert to dark blue with the text white. Can it be done??

Sandy

Hi Sandy

in CF, try "Formula Is)

=AND(A1="Miss",B1="")

Pick a yellow background

Pre-format the cell with a blue background first in Cell/Format.

Worked for me.

Beege

 

[Beege]

Hi Sandy

in CF, try "Formula Is)

=AND(A1="Miss",B1="")

Pick a yellow background

Pre-format the cell with a blue background first in Cell/Format.

Worked for me.

Beege

Helps to read the post correctly.

Should be

=AND(A1="Miss",A2="")

Beege

 

[Sandy]

Beege - You are a genius - Thank you
Sandy

Helps to read the post correctly.

Should be

=AND(A1="Miss",A2="")

Beege

 

[Beege]

Beege - You are a genius - Thank you
Sandy

You're welcome!