Forum Discussion
How to auto change the font color
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
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
