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