Conditional Formatting
 

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.
--
Many thanks for your help in advance. Have a wonderful day!
Zsolt

Conditional Formatting
 

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!
================================================== ===

"Zsolt Szabó" wrote in message
...
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.
--
Many thanks for your help in advance. Have a wonderful day!
Zsolt