bobhc I see that when values in column A are greater than that in column B the column B cells become green. and become red for vice versa. can you explain how its done??
Thanks for the help, its what I wanted.
By any chance is there a method to highlight the cell in Green when it true, and in Red when its False automatically?
Thanks Again.
I have Two values, say 250 in cell A1 and 350 in cell B1.
Now I want to check if the value in A1 is smaller than that in B1.
I wish to have a cell which shows when this statment is correct or is being violated. ( Say 100 in A1 and 25 in B1). Is there a method how to achieve this?
Thanks...