Nov 04 2021 07:52 AM
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
Nov 04 2021 08:07 AM
Solution@KHill21 This is a job for Conditional Formatting (Home tab -> Styles grouping) :
Highlight Column B and select New Rule:
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
and you should be all set
Nov 04 2021 08:07 AM
Solution@KHill21 This is a job for Conditional Formatting (Home tab -> Styles grouping) :
Highlight Column B and select New Rule:
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
and you should be all set