PDA

View Full Version : [SOLVED] Formulas and Conditional Formatting



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

Paul_Hossler
03-19-2012, 08:54 AM
Think this is what you're asking for, but my CF experience is limited


Paul

ozzyb77
03-19-2012, 09:20 AM
Paul, Thank you so much this is exactly what i wanted