View Single Post
  #3   Report Post  
lostgrave2001 lostgrave2001 is offline
Junior Member
 
Posts: 10
Smile

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 View Post
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