Take a look at "Conditional Formatting" in XL Help.




In article ,
fwburkey
wrote:

if cell A1 is larger than cell B1 to have it print in red .

Cell A1 is a constant number
Cell B1 is referenced from a different page
if cell B is less than cell A i want it to be red in color without
having to change the font