Conditional Formatting

[Guest]

Hi! I still have the two cells problem. A1 and E1. A1 : Font color is white,
Fill color is black and the cell now is empty. E1 : Font color is black, Fill
color is black and in the cell I typed a word. When or if A1 has any letter
or letters or it's not empty I like to change the Font color in E1 from black
to white.

 

[RagDyeR]

Select E1, then:
<Format> <Conditional Format>
Change to "Formula Is",
And enter:
=A1<>""

Then click "Format",
And choose White font, and OK out.
--

HTH,

RD
=====================================================
Please keep all correspondence within the Group, so all may benefit!
=====================================================

Hi! I still have the two cells problem. A1 and E1. A1 : Font color is white,
Fill color is black and the cell now is empty. E1 : Font color is black,
Fill
color is black and in the cell I typed a word. When or if A1 has any letter
or letters or it's not empty I like to change the Font color in E1 from
black
to white.