Google Spreadsheet Post #1541
Yogi Anand, D.Eng, P.E. ANAND Enterprises LLC -- Rochester Hills MI www.energyefficientbuild.com. Feb-21-2014
post by Brian Elwart (https://productforums.google.com/forum/#!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?
-----------------------------------------------------------------------------------------------------------------------------------------------
Yogi Anand, D.Eng, P.E. ANAND Enterprises LLC -- Rochester Hills MI www.energyefficientbuild.com. Feb-21-2014
post by Brian Elwart (https://productforums.google.com/forum/#!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),"
-----------------------------------------------------------------------------------------------------------------------------------------------
No comments:
Post a Comment