Google-sheets – Conditional formatting based on multiple cells

conditional formattinggoogle sheets

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?

Best Answer

Use conditional formatting in cell J3 with the formula =AND(ISBLANK(F3)=FALSE,G3>0)

Step-by-step:

Select cell J3 and click on Format > Conditional formatting
Select the options as in the screenshot below and paste the above formula in the required field.

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.

Related Solutions

Google Sheets – Formatting Cells Based on Upcoming Date

Suppose the dates are in column A, beginning with row 2, and cells to be formatted are in column B. Then you'd use conditional formatting with custom formula

=AND(A2<TODAY()+21, B2="no")

applying it to the range B2:B.

Google-sheets – Conditional formatting of an entire row based on multiple cells

Apply to a range such as A2:Z the conditional formatting with the custom formula

=and($L2="APPROVED", $M2="APPROVED", $N2="APPROVED", $O2 = "X")

Explanation

The formula is written as it should be applied to the upper left corner of the range, that is A2 here.
Dollar signs are used to make column references absolute, so that, for example, formatting of cell B2 would still refer to O2 and not to P2.
The row references are relative, so that, for example, third row cells refer to L3, M3, N3, and O3.

Best Answer

Related Solutions

Google Sheets – Formatting Cells Based on Upcoming Date

Google-sheets – Conditional formatting of an entire row based on multiple cells

Explanation

Related Topic