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

How can I do this?

Thanks
From John


--
Neo1
------------------------------------------------------------------------
Neo1's Profile: http://www.excelforum.com/member.php...o&userid=30329
View this thread: http://www.excelforum.com/showthread...hreadid=516432

select cell (A2?)
and do
format|conditional formatting
Cell value is:
Greater than 200

give it a nice format

Neo1 wrote:

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

How can I do this?

Thanks
From John

--
Neo1
------------------------------------------------------------------------
Neo1's Profile: http://www.excelforum.com/member.php...o&userid=30329
View this thread: http://www.excelforum.com/showthread...hreadid=516432

--

Dave Peterson

yes but I want it to be between a range such as 10 <x<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: http://www.excelforum.com/member.php...o&userid=30329
View this thread: http://www.excelforum.com/showthread...hreadid=516432

Neo,


Try this,..
Conditional Formatting
Formula is...

=AND($A$1<200,$A$110)
Format away

Beege

"Neo1" wrote in message
...

yes but I want it to be between a range such as 10 <x<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:
http://www.excelforum.com/member.php...o&userid=30329
View this thread: http://www.excelforum.com/showthread...hreadid=516432

Neo1 Wrote:
yes but I want it to be between a range such as 10 <x<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

the "between" 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: http://www.excelforum.com/member.php...o&userid=30486
View this thread: http://www.excelforum.com/showthread...hreadid=516432