Hi,

Am Mon, 20 May 2013 00:29:51 +0100 schrieb lostgrave2001:

I am trying to highlight an entire row (e1-e5) if E5 if over £9999.99. i
need the whole row to be highlighted in red is this possible?? im using
Excel 2003 to attempt this.

select E1:D5 = Conditional Formatting = New Rule = Use a formula to
determine which cells to format = formula:
=$E59999.99


Regards
Claus Busch
--
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2