ozzyb77
03-19-2012, 07:17 AM
Hi all
I have attached the following spreadsheet (Table One) and need some help with some fairly simple formatting.
I have a sent date column (H2) and when a date is entered i wish for the entire row to turn orange. I have a chase date column (J2) which is 14 days from the sent date, if the current date goes past the chase date i want the entire row to go red.
However then i have a results date column (K2 and L2) and if a date is entered here i want it to overide the previous 2 rules and turn the row green?
Is this simple enough? I've managed to do the first two rules but cant get the final rule to overide them when a date is entered?
Please help
Thanks
I have attached the following spreadsheet (Table One) and need some help with some fairly simple formatting.
I have a sent date column (H2) and when a date is entered i wish for the entire row to turn orange. I have a chase date column (J2) which is 14 days from the sent date, if the current date goes past the chase date i want the entire row to go red.
However then i have a results date column (K2 and L2) and if a date is entered here i want it to overide the previous 2 rules and turn the row green?
Is this simple enough? I've managed to do the first two rules but cant get the final rule to overide them when a date is entered?
Please help
Thanks