| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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! |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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! |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Macro recorded... tabs & file names changed, macro hangs | Excel Worksheet Functions | |||
| Macro Help Needed - Excel 2007 - Print Macro with Auto Sort | Excel Worksheet Functions | |||
| Need syntax for RUNning a Word macro with an argument, called from an Excel macro | Excel Programming | |||
| how to count/sum by function/macro to get the number of record to do copy/paste in macro | Excel Programming | |||
| Start Macro / Stop Macro / Restart Macro | Excel Programming | |||
Linear Mode
