Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
autofill colour based on date entry
I have a spreadsheet to record when monthly duty reports are received by each
employee and reviewed by mgmt. Column A1:A200 Employee Name Column B1:B200 Date Received in April Column C1:C200 Date Reviewed in April Column D1:D200 Date Received in May Column E1:E200 Date Reviewed in May etc Is there a formula I could use to fill the cell in grey when a report is not received when a report is received late in blue and when a report is received on time in pink? Reports received the 5th business day of the following month of the report (i.e. april report due the 5th business day in may) are considered late and reports reviewed after the 10th business day are late. Any suggestions without using code? Thanks!! :) |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Automating to autofill column B based on column A entry | Excel Discussion (Misc queries) | |||
Autofill cell based on todays date | Excel Worksheet Functions | |||
how do i autofill a cell a certain colour based on it's value? | Excel Worksheet Functions | |||
Default colour in cell based on specific entry | Excel Worksheet Functions | |||
Autofill date based on date in another cell | Excel Worksheet Functions |