Saturday, November 11, 2017

yogi_Conditionally Format When Specified Column Is >0 And Column To Its Right Is Not Blank

Google Spreadsheet   Post  #2277

Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     Nov-11-2017
question by: Lindsay Trenton
https://productforums.google.com/forum/?utm_medium=email&utm_source=footer#!topic/docs/ZnTICualYiU;context-place=forum/docs
Custom Formula with Conditional Formating
I am looking to put in a conditional formatting that will highlight all cells in a Column (Column D) that are greater than zero but does not have a blank cell to the right of it. I also need it to not highlight anything with text, namely a number of cells that say 'Balance'. I am having a hard time working out what Formula to use as everything I try has failed. Any suggestions?