Friday, August 1, 2014

yogi_Conditionally Format Rows B2 To 2 Red Green Yellow if Stock Levels Shown In Another Sheet Are Below 0 Greater Than stock.min Or Less Than stock.min

                           Google Spreadsheet   Post  #1718
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.   Aug-01-2014
post by Jonas Akuart:
(https://productforums.google.com/forum/#!mydiscussions/docs/OsjqOTXZQl4)
New Conditional Formatting option - Custom formula is
I've been experimenting with making Conditional Formatting work across pages, but it doesn't seem to be possible - anyone know anything about this?
---
To be a bit more specific, I'm trying something like this in my CF formula:
=anotherpage!a1>anotherpage!b1
---
Hi Yogi,

Thanks for the reply! =)

Yes, I mean across tabs in the same spreadsheet/workbook.

I've made a mock-up (with notes) of the desired effect and the formulas I've attempted, viewable here:

Hope it makes sense, and thanks for your time =)
-------------------------------------------------------------------------------------------------------------------------------------------------