If you want to apply to B2:B10 so that all cells are coloured red if
greater than column A in same row
select B2:B10
Format Conditional Formatting Formula is
=B2A2
select red formatting
--
daddylonglegs
------------------------------------------------------------------------
daddylonglegs's Profile:
http://www.excelforum.com/member.php...o&userid=30486
View this thread:
http://www.excelforum.com/showthread...hreadid=515532