J
Julian Campbell
Hello all
Is there a way to do the following
I will have two columns A = Kill Date B = Use by date - I would like to set
the cell in which the use by date is entered to change colour (Have tried to
use conditional format but failed) So for intance
KILL DATE 1/1/06
USE BY DATE 15/1/06
FOR DATES 1 TO 5 CELL COLOUR GREEN
DATES 5 TO 10 CELL COLOUR AMBER
DATES 10 TO 15 CELL COLOUR RED
I want to use this as an alert to correct use of raw meat within my
workplace
Any help would be good
Thanks
Julian
Is there a way to do the following
I will have two columns A = Kill Date B = Use by date - I would like to set
the cell in which the use by date is entered to change colour (Have tried to
use conditional format but failed) So for intance
KILL DATE 1/1/06
USE BY DATE 15/1/06
FOR DATES 1 TO 5 CELL COLOUR GREEN
DATES 5 TO 10 CELL COLOUR AMBER
DATES 10 TO 15 CELL COLOUR RED
I want to use this as an alert to correct use of raw meat within my
workplace
Any help would be good
Thanks
Julian