Friday, February 21, 2014

yogi_Conditional Formatting For Multiple Ranges For A Combination Of AND OR Conditions Using Google New Sheets

                                         Google Spreadsheet   Post  #1541
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI   Feb-21-2014
post by Brian Elwart   (!mydiscussions/docs/WHppdEsPW7g)
Conditional Formatting - Shade one cell based on another
I have created a generic version ofthe spreadsheet. Here is a link. I have been able to create the proper formula (=IF(AND(L6="",TODAY()>G6),"Late","OK"), see column P. I can then create the conditional formatting formula based on the result of that formula, see column D. However, I can not have the formula in column P be the custom formula in the conditional formatting. Is there a way to do this and eliminate an extra step?