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 :)

--
oldLearner57