Saturday, July 26, 2014

yogi_Conditionally Format Entire Row if Value In Column A (amount owed) is equal to the Value in Column C (amount collected)

                            Google Spreadsheet   Post  #1710
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.   Jul-26-2014
post by uncel_sean:
(https://productforums.google.com/forum/#!mydiscussions/docs/f-D9nA6FzZA)
Conditional Formatting, Custom Function to highlight a whole row
Hello,

I'm trying to get an entire row's background to turn light green when the following conditions are met: A3 = C3.

For example A3 is "money owed" and C3 is "money collected."  When those 2 cells are equal, I want the whole row to be highlighted in light green.

What do I need to do to make this happen?
-------------------------------------------------------------------------------------------------------