software

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.


go in tools and click on the 4th thing, I only have the french version,
its called quot;mise en forme automatiquequot;, in english it should looks like
: quot;automatic cell setupquot; (i really dunno)--
anyways
------------------------------------------------------------------------
anyways's Profile: www.excelforum.com/member.php...oamp;userid=31815
View this thread: www.excelforum.com/showthread...hreadid=515376
Click on A4 and then choose Format, Conditional Format Under
Condition 1 you should see Cell Values, click on the arrow and change
it to Formula is, in the box next to this put in this formula
=A4gt;=G4 then click on format and choose how you would like to see it
displayed then click on OK and you should be set.--
intruder9
------------------------------------------------------------------------
intruder9's Profile: www.excelforum.com/member.php...oamp;userid=30107
View this thread: www.excelforum.com/showthread...hreadid=515376