Hello sorry for the late replay, im using excel 2003 it will not allow me to use a new rule. do you know of another way to do this?
Thank you
Quote:
Originally Posted by Claus Busch
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
|