I'm trying to figure out how to write a formula for Google Spreadsheet where:
If F3 Contains Data and G3 is more than 0 then cell J3 is Highlighted in Green
Can anyone help me out with this?
Web Applications Stack Exchange is a question and answer site for power users of web applications. It only takes a minute to sign up.Sign up to join this community
Use conditional formatting in cell J3 with the formula =AND(ISBLANK(F3)=FALSE,G3>0)
Conditional formatting is applied if the formula results to TRUE. This will only be the case if both the cell F3 is not be blank (= contains data) and if cell G3 is higher than 0.