Formula's

S

ShellH

I want Excel to automatically highlight a figure or change colour of it's
font once it is equal to or greater than the figure in a different box e.g

Once the figure in A4 is equal to or exceeds the figure in G4 I would like
the font to be either red or the box to be highlighted yellow.
 
A

anyways

go in tools and click on the 4th thing, I only have the french version,
its called "mise en forme automatique", in english it should looks like
: "automatic cell setup" (i really dunno)
 
I

intruder9

Click on A4 and then choose Format, Conditional Format Unde
Condition 1 you should see Cell Values, click on the arrow and chang
it to Formula is, in the box next to this put in this formula
=A4>=G4 then click on format and choose how you would like to see i
displayed then click on OK and you should be set
 
Top