Solved Compare values after row difference

March 9, 2015 at 09:45:38
Specs: Windows 7
I have a spreadsheet with several columns and I have been able to use "Row Difference" to highlight different cell values; however, I would like to take it one step further ... is there a way that I can compare the value and change text color to green if the value is lower and change the text color to red if the value is greater. In the example below, $1,000 would be red text and $250 would be green text, then $15 would be green text and $50 would be red text.

Column A Col B Col C Col D
Deductible $500 $1,000 $250
Copay $25 $15 $50

See More: Compare values after row difference

Report •

March 9, 2015 at 10:26:50
✔ Best Answer
Conditional Formatting should work for you.

Here's a How-To on this forum or you could perform a web search more information.

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

Report •
Related Solutions

Ask Question