Conditional formatting

S

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
 
B

Beege

Sandy said:
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
Click to expand...

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
 
B

Beege

Beege said:
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
Click to expand...


Helps to read the post correctly.

Should be

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

Beege
 
Top