Excel '07 Change Font Color Based on # range

August 29, 2011 at 05:38:21
Specs: Windows 7
For data purposes, I have a cell with a value "12.008". This is a fixed value. In the following cell, I will enter a value that is close to this number. If this cell value is greater than 0.125, above or below the previous cell, then I need the value entered to be RED. If it falls within the range of 0.125 above or below, the need the value to be BLACK.

example: cell1(12.008), cell2(12.110).....True, remains BLACK b/c it is within the range of 0.125, above or below.

example: cell1(11.523), cell2(11.950).....False, text entered becomes RED b/c it is outside of the accepted range of 0.125, above or below.

Any help is greatly appreciated!

See More: Excel 07 Change Font Color Based on # range

Report •

August 29, 2011 at 06:47:30
Read up on Conditional Formatting in the Excel Help files.

You can set Conditions (2003) or Rules (2007+) to monitor the values entered into the cell and compare it to the other cell.

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

Report •
Related Solutions

Ask Question