Conditional Formatting with Relative Reference.
Sample workbook:
A B C D E F
1. 4.5 6 7.4 8.3 10 2
2. 1 2 3 4 3 2
3. 1 2 3 4 5 6
4. 6 5 4 3 2 1
Hi,
How can Excel 2003 workbook be designed so that if a value of a cell is
smaller or greater than the value of the cell, then color of the cell is
auto formatted ?
Formatting of the cell is as follows: Green if value is greater and Red if
the value is smaller.
Desired result based on the above sample workbook:
A B C D E F
1. 4.5 Green Green Green Green Red
2. 1 Green Green Green Red Red
3. 1 Green Green Green Green Green
4. 6 Red Red Red Red Red
Peter
Bookmarks