Wednesday, May 21, 2014

yogi_Apply Conditional Formatting To Specified Range (A2 to D5) Based On Values In Column C


                                         Google Spreadsheet   Post  #1643
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.   May-20-2014
post by vincentvc -- question by zander Bingle: (https://productforums.google.com/forum/#!mydiscussions/docs/t6xPcOkjNbQ)
Conditional formatting cell to entire line
Hi Yogi

You'll see I've got two example tables, using the indirect formula, it works perfectly (first table). When using a straight forward relative reference, it doesn't work at all :/ It's basically assuming that you you want to validate the formatting for the whole table based on that one cell only, yet only formats the first cell in the specified range.

I don't know if Google is planning on changing the manor in which Conditional Formatting will react when formatting a whole table based on a single column. I know for a fact that there are very little people aware of the indirect function, even in Excel.

Example document:
https://docs.google.com/spreadsheets/d/1mELOR9bxYyuBjpjh0n8zNCUAFRyQ4XqIfrC7pdzB3x0/edit?usp=sharing

Please let me know should you require any additional information.

I've only recently started using Google docs, loving it and tinkering for personal use only. So it's not a train smash ;)

Kind Regards
Zander Bingle
----------------------------------------------------------------------------------------------------------------------------------------------------------
I think the question by implications is ... must one use INDIRECT function in such a case as Zander has used --
my following illustration shows that one does not necessarily need to use the INDIRECT function