Changing the apperance of values
 

I have a work book showing a quantity on hand, quantity in stock and the
variance between them. I am wanting to formate my variance column to change
eveny value greater than 5 to show as red (or make every value grater than 5
stand out in some way). Thank you for helping.

Changing the apperance of values
 

Say a variance is in cell C5. Select the cell and pull-down:

Format Conditional Formatting... Formula Is:
=C15 and then set the font color to red.

--
Gary''s Student - gsnu200789


"Rhatch" wrote:

I have a work book showing a quantity on hand, quantity in stock and the
variance between them. I am wanting to formate my variance column to change
eveny value greater than 5 to show as red (or make every value grater than 5
stand out in some way). Thank you for helping.

Changing the apperance of values
 

Thank you, our inventory count is gong to run much smoother now.
Thanks again!!
"Gary''s Student" wrote:

Say a variance is in cell C5. Select the cell and pull-down:

Format Conditional Formatting... Formula Is:
=C15 and then set the font color to red.

--
Gary''s Student - gsnu200789


"Rhatch" wrote:

I have a work book showing a quantity on hand, quantity in stock and the
variance between them. I am wanting to formate my variance column to change
eveny value greater than 5 to show as red (or make every value grater than 5
stand out in some way). Thank you for helping.