Cell coloring condition

[VBisgreat]

Hi,

I need a formula or macro that can help me with: I have a cell A1, if the user enters a number greater than or equal to 2 and less than or equal to 6 then turn that cell to green (2≤x≤6), if less than 2 then turn yellow, and greater than 6 turn red.
Thanks

VBisgreat

[TMS]

Have you looked at Conditional Formatting?

Regards

[Paul]

Hi VB,

Use Conditional Formatting for this. See here for some basic examples:

http://www.contextures.com/xlcondFormat01.html

[VBisgreat]

thank you for your helps.