JohnyG
09-04-2008, 10:11 PM
I have a worksheet contains 4 columns. Please find attached the sample output sheet for the same.
Need to develop some calculation logic.Logic goes like :
Value of Column D is calculated basis two formulas.
Formula 1: Due Date - Contact Date.(calculate only working days)
Now if the value of Column D value (Lead Time) is >= 7 and value of Column 1(Request Type) is "RFI" then Column D cell background color changed to green else red.
Similarly if the value of COlumn D (Lead Time) is >= 14 and value of Column 1(Request Type) is "RFP" then COlumn D cell background color changed to green else red.
If Column A contains anyother value apart from "RFI" or "RFI" then no output is required in COlumn D.
Please help
Regards,
Need to develop some calculation logic.Logic goes like :
Value of Column D is calculated basis two formulas.
Formula 1: Due Date - Contact Date.(calculate only working days)
Now if the value of Column D value (Lead Time) is >= 7 and value of Column 1(Request Type) is "RFI" then Column D cell background color changed to green else red.
Similarly if the value of COlumn D (Lead Time) is >= 14 and value of Column 1(Request Type) is "RFP" then COlumn D cell background color changed to green else red.
If Column A contains anyother value apart from "RFI" or "RFI" then no output is required in COlumn D.
Please help
Regards,