Formula for "highlighting" data

[Guest]

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.

 

[Bob Phillips]

Try conditional formatting, Format>Conditional Formatting. It will handle 3
colours.

 

[Andy Brown]

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

 

[Guest]

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.