SOLVED

How to auto change the font color

Copper Contributor

Hello

How do you set up a function to have the font color of a cell change based on information entered in the cell prior.

 

Column "B" has a default number listed in each row = "56"  and the font color is a light gray

When the number entered in column "A" is greater than "0" I want the font color in column "B" of that row to change to black. But if it remains at "0" or 'blank" then it needs to stay light gray.

 

Can this be done?

 

Thanks 

2 Replies
best response confirmed by allyreckerman (Microsoft)
Solution

@KHill21 This is a job for Conditional Formatting (Home tab -> Styles grouping) :

mtarler_0-1636038186224.png

Highlight Column B and select New Rule:

mtarler_1-1636038252112.png

Then select "Use a formula to determine which cells to format"

click on Format to set your formatting.

In the formula box if you want any cell that the corresponding cell in column A has a value in it to get that formatting then you just need a formula "=A1" of "=$A1" if you want it to apply to additional columns past B

mtarler_2-1636038466053.png

 

and you should be all set

Sweet. Thank you so much!
1 best response

Accepted Solutions
best response confirmed by allyreckerman (Microsoft)
Solution

@KHill21 This is a job for Conditional Formatting (Home tab -> Styles grouping) :

mtarler_0-1636038186224.png

Highlight Column B and select New Rule:

mtarler_1-1636038252112.png

Then select "Use a formula to determine which cells to format"

click on Format to set your formatting.

In the formula box if you want any cell that the corresponding cell in column A has a value in it to get that formatting then you just need a formula "=A1" of "=$A1" if you want it to apply to additional columns past B

mtarler_2-1636038466053.png

 

and you should be all set

View solution in original post