Change color font if value is greater

Beth - Nov 17, 2010 at 06:39 PM
 Beth - Nov 18, 2010 at 04:12 PM

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 responses

venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 811
Nov 17, 2010 at 08:54 PM
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
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!!