Change Font Characteristic

[Giovanna]

It is possible to make a VBA program where I can change the font color,
patterns and style when the number is out of specification?
For example, if I have the following:
A Column B Column
95 90 to 100
55 60 to 89
36 40 to 59
15 0 to 39
Therefore, A2 and A3 will have white font color with red patterns and bold
style.

Thank you for you support.
Giovanna

 

[Gary's Student]

A suggestion:

Use Column B for the lower limit and Column C for the high limit.

Then you can apply conditional formatting to the cells in Column A

 

[Giovanna]

Gary;
Thank you very much for your advise.
I did the program and it is working!!!!!!

Regards.
Giovanna