Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Formula for "highlighting" data
I am currently working on a template for a coworker that allows them to
quickly see which products need to be ordered now, soon, or not in the forseeable future. I have been able to get to the point where the macro will tell them to "order now", "order soon", or "out of stock". I would like to be able to highlight the different categories in different colours (i.e. yellow for "order soon", red for "order now", and some other colour for "out of stock". Any help is greatly appreciated. |
#2
|
|||
|
|||
Try conditional formatting, FormatConditional Formatting. It will handle 3
colours. -- HTH Bob Phillips "John" wrote in message ... I am currently working on a template for a coworker that allows them to quickly see which products need to be ordered now, soon, or not in the forseeable future. I have been able to get to the point where the macro will tell them to "order now", "order soon", or "out of stock". I would like to be able to highlight the different categories in different colours (i.e. yellow for "order soon", red for "order now", and some other colour for "out of stock". Any help is greatly appreciated. |
#3
|
|||
|
|||
John wrote:
I am currently working on a template for a coworker that allows them to quickly see which products need to be ordered now, soon, or not in the forseeable future. I have been able to get to the point where the macro will tell them to "order now", "order soon", or "out of stock". I would like to be able to highlight the different categories in different colours (i.e. yellow for "order soon", red for "order now", and some other colour for "out of stock". Any help is greatly appreciated. If 3 colours is all you need, consider conditional formatting (sans macro). See http://www.contextures.com/xlCondFormat01.html for details. HTH, Andy |
#4
|
|||
|
|||
Thanks. I was able to record the conditional formatting to make it one macro
for the user. It works exactly as planned. Time for user testing. "Bob Phillips" wrote: Try conditional formatting, FormatConditional Formatting. It will handle 3 colours. -- HTH Bob Phillips "John" wrote in message ... I am currently working on a template for a coworker that allows them to quickly see which products need to be ordered now, soon, or not in the forseeable future. I have been able to get to the point where the macro will tell them to "order now", "order soon", or "out of stock". I would like to be able to highlight the different categories in different colours (i.e. yellow for "order soon", red for "order now", and some other colour for "out of stock". Any help is greatly appreciated. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Printing data validation scenarios | Excel Worksheet Functions | |||
Line Graph Data Recognition | Charts and Charting in Excel | |||
ENTER A FORMULA IN A CELL TO UTILIZE THE IMPORT DATA FUNCTIONS? | Excel Worksheet Functions | |||
Excel2K: Is it possible to use dynamic named ranges in custom data validation formula? | Excel Discussion (Misc queries) | |||
matching data formula? | Excel Worksheet Functions |