Format/ Conditional Formatting/ Formula Is/ then complete as applicable, but
make sure you start your formula with the = sign, or else Excel often makes
some strange guesses as to what you intended.
--
David Biddulph

"Timmy" wrote in message
...
I have a worksheet with cell A1 with a certain number and cell A2 with
another number in it. I would like to compare cells A1 vs A2.

If the value is less than A2, then the cell A3 should be highlighted in
yellow
If the value is equal to A2, then highlight the cell A3 in green
If the value is higher than A2, highlight the cell A3 in red

Thanks in advance.