Hello basically I want the cell that has an IF statement to appear coloured according to the IF statement made for example IF A2>100 then i want cell to appear blue....
How can I do this?
Thanks
From John
Hello basically I want the cell that has an IF statement to appear coloured according to the IF statement made for example IF A2>100 then i want cell to appear blue....
How can I do this?
Thanks
From John
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 A2>100 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
Neo,
Try this,..
Conditional Formatting
Formula is...
=AND($A$1<200,$A$1>10)
Format away
Beege
"Neo1" <[email protected]> wrote in message
news:[email protected]...
>
> 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
>
the "between" option should work for this. 2 possible problems:Originally Posted by Neo1
Did you remember to include a format?
Does your cell contain a number or text that looks like a number?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks