Format the color font depending on the value of another cell

Closed
SADY1106 Posts 1 Registration date Friday August 19, 2016 Status Member Last seen August 19, 2016 - Aug 19, 2016 at 06:09 PM
Mazzaropi Posts 1965 Registration date Monday August 16, 2010 Status Contributor Last seen September 18, 2022 - Aug 19, 2016 at 07:30 PM
Im new to Excel. Is there away or formula to change the color font of a cell depending on another cell?
I want my text in colum A B C to be the font color RED and change to the color GREEN once i type any text in on colum E.
can any one help?

1 reply

Mazzaropi Posts 1965 Registration date Monday August 16, 2010 Status Contributor Last seen September 18, 2022 146
Aug 19, 2016 at 07:30 PM
SADY1106, Good evening.

You can use a Conditional Formatting function.

Suppose your data: A1:C100

Select your data range A1:C100
Go to Conditional Format Menu
New Rule
Using Formula

1) Rule
Type --> $E1<>""
Choose --> Fill Color GREEN
OK

2) Rule
Type --> $E1=""
Choose --> Fill Color RED
OK

OK

Please, tell us if it worked for you.

Is this what you want?
I hope it helps.
--
Belo Horizonte, Brasil.
Marcílio Lobão
0