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

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
--
Gary's Student


"Giovanna" wrote:

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;
Thank you very much for your advise.
I did the program and it is working!!!!!!

Regards.
Giovanna

"Gary's Student" wrote:

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
--
Gary's Student


"Giovanna" wrote:

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