software

Hello basically I want the cell that has an IF statement to appear
coloured according to the IF statement made for example IF A2gt;100 then
i want cell to appear blue....

How can I do this?

Thanks
From John--
Neo1
------------------------------------------------------------------------
Neo1's Profile: www.excelforum.com/member.php...oamp;userid=30329
View this thread: www.excelforum.com/showthread...hreadid=516432select cell (A2?)
and do
format|conditional formatting
Cell value is:
Greater than 200

give it a nice format

Neo1 wrote:
gt;
gt; Hello basically I want the cell that has an IF statement to appear
gt; coloured according to the IF statement made for example IF A2gt;100 then
gt; i want cell to appear blue....
gt;
gt; How can I do this?
gt;
gt; Thanks
gt; From John
gt;
gt; --
gt; Neo1
gt; ------------------------------------------------------------------------
gt; Neo1's Profile: www.excelforum.com/member.php...oamp;userid=30329
gt; View this thread: www.excelforum.com/showthread...hreadid=516432

--

Dave Peterson


yes but I want it to be between a range such as 10 lt;xlt;200

I try putting between in conditional formatting and then i put between
10 and 200, but it doesnt seem to work

Any Help please?

Thanks
From John--
Neo1
------------------------------------------------------------------------
Neo1's Profile: www.excelforum.com/member.php...oamp;userid=30329
View this thread: www.excelforum.com/showthread...hreadid=516432Neo,Try this,..
Conditional Formatting
Formula is...

=AND($A$1lt;200,$A$1gt;10)
Format away

Beege

quot;Neo1quot; gt; wrote in message
...
gt;
gt; yes but I want it to be between a range such as 10 lt;xlt;200
gt;
gt; I try putting between in conditional formatting and then i put between
gt; 10 and 200, but it doesnt seem to work
gt;
gt; Any Help please?
gt;
gt; Thanks
gt; From John
gt;
gt;
gt; --
gt; Neo1
gt; ------------------------------------------------------------------------
gt; Neo1's Profile:
gt; www.excelforum.com/member.php...oamp;userid=30329
gt; View this thread: www.excelforum.com/showthread...hreadid=516432
gt;

Neo1 Wrote:
gt; yes but I want it to be between a range such as 10 lt;xlt;200
gt;
gt; I try putting between in conditional formatting and then i put between
gt; 10 and 200, but it doesnt seem to work
gt;
gt; Any Help please?
gt;
gt; Thanks
gt; From John

the quot;betweenquot; option should work for this. 2 possible problems:

Did you remember to include a format?

Does your cell contain a number or text that looks like a number?--
daddylonglegs
------------------------------------------------------------------------
daddylonglegs's Profile: www.excelforum.com/member.php...oamp;userid=30486
View this thread: www.excelforum.com/showthread...hreadid=516432