Quick question regariding formatting

[Uncle Vinnie]

Is there a way to set up cells in a single column where the contents would
stand out when below a certain number?

In my case, each column represents an item a list of customers have in
stock. When the inventory falls below a certain number that I would define,
it would stand out, perhaps in red, or bold, parenthesis - anything outside
of the normal font would help.. thank you!

 

[Gord Dibben]

Vinnie

Format>Conditional Formatting will do the trick.

Select the column or range and Format>CF>Cell Value is:


Gord Dibben MS Excel MVP

 

[Uncle Vinnie]

Thank you for the info and the quick reply- I'll try it!

(Forgot to mention Office 2000!)

Thanks again!

 

[Uncle Vinnie]

This is great.. in all these years, never knew it was there.. thanks Gord!
I will tinker a bit, I noticed it does not highlight zeroes, but I'll keep
working on it..

Again, thank you!