conditional formatting

[oldLearner57]

hi community

how can I use the Formula Is in the Conditional Formatting dialog box in
this scenario..

A B
1 7500
2 10000
3 3000

how to have the value in cell A1, A2, A3 data to have font color when each
cell satisfy the following condition...

<=3000 be "Red" / <=7500 be "Green" / <=10000 be "Tan"

I tried using the Conditional Formatting with Cell Value is, I can do only
for Pattern color but I wish to use the Formula Is and turn only the number
into their respective color..

can anybody kindly enlighten me on this...

thanks community for the kind assistance

 

[Pete_UK]

Highlight the three cells A1:A3, with A1 as the active cell, then in
the CF dialogue box select Formula Is rather than Cell Value Is, and
enter this formula:

=A1<=3000

Click the Format button, select Colour, and choose Red - this affects
the foreground colour. Click OK, and then Add to set up your second
condition - choose Formula Is and enter this formula:

=A1<=7500

and format with a Green foreground colour. Ok again, then Add and set
up your 3rd condition - Formula Is, with:

=A1<=10000

then choose Tan for the foreground colour. This time click OK twice to
exit the CF dialogue box. Excel will have adjusted the formulae to
suit the other cells that were highlighed, so you should see the
effects immediately.

Hope this helps.

Pete

 

[oldLearner57]

thanks Pete
got it

thanks community as well

 

[Pete_UK]

You're welcome - thanks for feeding back.

Pete

thanks Pete
got it

thanks community as well
--
oldLearner57






- Show quoted text -