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!