How to formulate the following.....
Posted by Steve on November 28, 2000 7:47 PM
Greetings
here goes,
Cell B6 = value1
Cell B7 = value2
If B7 is less than B6 then the font (or background color) of B7 equals red.
If B7 is greater than B6 then the font (or background color) of B7 equals blue.
If B7 contains no value then nothing is done.
This is a simplified example of what I am trying to do. No need to get confused with facts and figures. =P
Anyone have an answer for this? I'm new and stumped.
Thanks
Steve