Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
sorting a range with conditional formatting | Excel Worksheet Functions | |||
conditional formatting glitches | Excel Discussion (Misc queries) | |||
Keeping conditional formatting when sorting | Excel Discussion (Misc queries) | |||
conditional formatting | Excel Discussion (Misc queries) | |||
cannot use ISEVEN or ISODD functions in Conditional Formatting | Excel Worksheet Functions |