Change color font if value is greater
Solved/Closed
Related:
- Change color font if value is greater
- Notepad++ change background color - Guide
- Html font color - Guide
- Change computer name cmd - Guide
- Change lg tv name - Guide
- What color is audio out on pc - Guide
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
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
=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
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
