Can this be achieved by Google Sheets conditional formatting feature?
Google-sheets – How to colourise a range of cells based on a start & end date
google sheets
Related Solutions
You can use a range as a parameter for the ISFORMULA() function.
e.g. If you want to highlight all cells containing formulas in the range A1:J10, then you can use the formula =ISFORMULA(A1:J10) and apply it to the range A1:J10.
Note that this works with normal ranges (e.g. B2:F30), but not with infinite ranges (e.g. B:F).
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.
Related Topic
- Google Sheets – Conditional Formatting with Multiple Criteria for a Range of Cells
- Google Sheets – Conditional Formatting Based on Single Cell Value
- Fixing Custom Formula Conditional Formatting Highlighting Empty Cells in Red
- Google Sheets – Format Cells if Date is Within Last 30 Days
- Google Sheets – Use Checkbox to Change Background Color of Cells
- Google-sheets – Conditionally format cells that not match with range from Sheet2
- Google-sheets – Disable Conditional Formatting without deleting the rules
- Google-sheets – How to unlink two columns in Google Sheets in regards to conditional formatting
Best Answer
Just type in a function yielding a number for each cell colour you want to use, and set the text colour to none, like:
This will yield 1 if the date on line 3 is between those of columns D and E, and zero otherwise.