Change color font if value is greater

[Solved/Closed]
Report
-
 Beth -
Hello,

I'm trying to get the formula based on this: if cell b1 is greater than cell a1 (a1 always changes), make font color red (formula to be copied down the column). Thank you in advance for your help!



2 replies

Posts
1864
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
802
the best would be to do conditional formatting

I suppose if b1 >a1 you want to color cell B1 in red

select B1
click format(men9)-conditional formatting
in the conditional formatting window click the arrow under "condition1" and choose "the formula is"
in the right window copy this formula
=B1>A1
click "format" in the middle row
in the "format cells" window
choose "Pattern" at the end of the line at the top
in the color screen choose your color
click OK
again click OK
now select B1 and hit control+C
select B2 to the last data in column B
click edit-pastespecial
in the paste special window click "format"
click OK


now it is ready. if A column data changes automatically correct color will come up in col. B
Thank you so much for the help, it worked perfectly!!

~~Beth