Hello,
I've gone through some of the previously posted threads but didn't see one to match closely to what I'm looking for in a condition(s).
I have a table (A11:X160) that I want each row to react based on the follow condition types. (Note this table is a "Question Tracking Log" and each row represents a question report that is automatically feed from other worksheet. "reports")
Here are the headers to the three inspected columns. Column G is "Date Submitted To Customer" / Column H is "Response Deadline" / Column I is "Date Answered"
Condition #1
I want the specific table row to turn Blue when a date is in Column G(not blank) and todays date is 5 days or less than the date in Column H and Column I is empty.(In Ex. Today=11/10-11/17)
Condition #2
I want the specific table row to turn Orange when a date is in Column G(not blank) and todays date is within 2 days of Column H and Column I is empty. (In Ex. Today=11/18-11/19)
Condition #3
I want the specific table row to turn Red when a date is in Column G(not blank) and todays date on or past Column H and Column I is empty. (In Ex. Today=11/20and past)
In all of these conditions if there a client response in Column I then these conditions must be ignored. Basically if answered no reason to monitor the rows status any longer.
Thanks in advance for the help.
I've gone through some of the previously posted threads but didn't see one to match closely to what I'm looking for in a condition(s).
I have a table (A11:X160) that I want each row to react based on the follow condition types. (Note this table is a "Question Tracking Log" and each row represents a question report that is automatically feed from other worksheet. "reports")
Here are the headers to the three inspected columns. Column G is "Date Submitted To Customer" / Column H is "Response Deadline" / Column I is "Date Answered"
Condition #1
I want the specific table row to turn Blue when a date is in Column G(not blank) and todays date is 5 days or less than the date in Column H and Column I is empty.(In Ex. Today=11/10-11/17)
Condition #2
I want the specific table row to turn Orange when a date is in Column G(not blank) and todays date is within 2 days of Column H and Column I is empty. (In Ex. Today=11/18-11/19)
Condition #3
I want the specific table row to turn Red when a date is in Column G(not blank) and todays date on or past Column H and Column I is empty. (In Ex. Today=11/20and past)
In all of these conditions if there a client response in Column I then these conditions must be ignored. Basically if answered no reason to monitor the rows status any longer.
Thanks in advance for the help.