Sunday, January 26, 2014

yogi_Conditionally Format Cells D3 to D6 (Background green) If Value In Cell Is > Value in Cell A1 of AnotherTab

                                         Google Spreadsheet   Post  #1498
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.   Jan-26-2014
post by sgupta1717 (http://productforums.google.com/forum/#!category-topic/docs/spreadsheets/how-do-i/chrome-browser/i-B4f00LEuI)
Reference a different tab in conditional formatting
Hi.  In the new Google Sheets, is anyone able to reference a cell in a different tab when doing conditional formatting?  This is what I want to do:

Custom formula:  =D3>AnotherTab!$A$1
Format:  Make the background green
Range:  D3:D6

However, I get an "Invalid Formula" error whenever I try to reference a different tab.
------------------------------------------------------------------------------------------------------------------------------------------------------------