Macro

  • Thread starter Thread starter Rey
  • Start date Start date
R

Rey

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!
 
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...
 
Thanks a million. Worked like a charm.

James said:
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...
Click to expand...
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Counting multiple memberships 1
Macro? 2
export xml source mapping 1
Worsheet selection 5
how to convert COUNTIF() into VBA macro 0
Complicated search and complete analysis on results 4
HELP: Populate Excel FORM from Access - Pull from multiple rows 3
Determine if specific text is in a cell 6

Back
Top