Cell Formating

[blueman]

Hello

I am trying to set up a spreadsheet whereby the cells will change colour depending on how old a product is.

The date of production of the produt is entered in cell, say A1

this cell would change colour as it get older. If it is was > 50 the cell would be red

if > 30 > 48 the cell would be amber and if it was > 29 it would be green
if the cell was blank the cell would have no colour.

Any help would be very much appreciated.

REGARDS


BLUEMAN

[oldchippy]

Hi,

Welcome to the forum, you can use conditional formatting something like this