| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Macro to change cell color
I have little macro experience and I need to change the color of the cell
when a condition is met. I would appreciate any help. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Macro to change cell color
Patti,
You don't need a macro. You can accomplish what you want using the Conditional Formatting tool on the Format menu. -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "Patti F" wrote in message ... I have little macro experience and I need to change the color of the cell when a condition is met. I would appreciate any help. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Macro to change cell color
If you have just one condition, you may use Format - Conditional formating
instead. It can handle complicated conditions, check the help file. "Patti F" wrote: I have little macro experience and I need to change the color of the cell when a condition is met. I would appreciate any help. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Macro To Change Cell Color (Continued) | Excel Worksheet Functions | |||
| Macro To Change Cell Color When Value Changes | Excel Worksheet Functions | |||
| Event Macro adjustment needed - need to change font color also | Excel Worksheet Functions | |||
| Possible Lookup Table | Excel Worksheet Functions | |||
| Copy cell format to cell on another worksht and update automatical | Excel Worksheet Functions | |||
Linear Mode
