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
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.
------------------------------------------------------------------------------------------------------------------------------------------------------------
No comments:
Post a Comment