software

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
Julian

Something like:

Condition 1: Formula is: =$B2lt;=$A2 5 format interior to green
Condition 2: Formula is: =$B2lt;=$A2 10 format interior to amber
Condition 3: Formula is: =$B2gt;$A2 10 format interior to red

Regards

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