Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
date validation MAYBE
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
date validation MAYBE
Julian
Something like: Condition 1: Formula is: =$B2<=$A2+5 format interior to green Condition 2: Formula is: =$B2<=$A2+10 format interior to amber Condition 3: Formula is: =$B2$A2+10 format interior to red Regards Trevor "Julian Campbell" wrote in message ... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Date Validation - Must equal Sundays date | Excel Discussion (Misc queries) | |||
Adding XY days to date in cells | Excel Discussion (Misc queries) | |||
Another Date issue. | Excel Worksheet Functions | |||
Date Math Problem | Excel Worksheet Functions | |||
Need help troubleshooting an array formula XLXP on Win2K | Excel Worksheet Functions |