Macro
 

I am trying to create a macro that highlights values. I created a worksheet
that reflects that grades of my students. If a particular value (grade)
falls below a predetermined value (grade) I want the cell(s) to highlight
red. I've tried using several methods but not worked. HELP!

Macro
 

G'Day Rey,

You can do this via Conditional Formatting within Excel itself rather than
via a VBA Macro. In Excel 2003 you can create up to 3 types of conditional
formats, in Excel 2007 I believe that that there is not a limit? I have yet
to test this though...


"Rey" wrote in message
...
I am trying to create a macro that highlights values. I created a
worksheet
that reflects that grades of my students. If a particular value (grade)
falls below a predetermined value (grade) I want the cell(s) to highlight
red. I've tried using several methods but not worked. HELP!

Macro
 

Thanks a million. Worked like a charm.

"James" wrote:

G'Day Rey,

You can do this via Conditional Formatting within Excel itself rather than
via a VBA Macro. In Excel 2003 you can create up to 3 types of conditional
formats, in Excel 2007 I believe that that there is not a limit? I have yet
to test this though...


"Rey" wrote in message
...
I am trying to create a macro that highlights values. I created a
worksheet
that reflects that grades of my students. If a particular value (grade)
falls below a predetermined value (grade) I want the cell(s) to highlight
red. I've tried using several methods but not worked. HELP!