I have a column A. I want to apply a custom background color to the cell A1 only when each cell in the range C1:T1 contains "Y" (literal letter uppercase Y).
This formatting will be repeated for each row in the sheet.
Is it possible?
Google-sheets – Conditional formatting one cell when all cells in a range have a particular value
conditional formattinggoogle sheets
Related Solutions
With the range set to: B3:O1000
Try:
=AND(ISBLANK(B3),INT($A3)=INT(today()))
or even shorter:
=AND(ISBLANK(B3),$A3=today())
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).
Related Topic
- Applying Conditional Formatting Color Scale to Non-Numerical Cells in Google Sheets
- Google-sheets – Copying Cell Color from Conditional Formatting in Google Sheets
- Google-sheets – Apply conditional formatting to one column
- Google-sheets – Conditional formatting cells with multiple conditions and relative references over a range
- Google-sheets – Google Sheets Conditional Formatting based on Text and another cell
- Google Sheets – How to Apply Conditional Formatting Based on Specific Formula
Best Answer
Please select A1 and apply a Custom formula is of:
Select your background colour.
Either extend the selection range from A1 to suit before the above, change the Apply to range after or copy down to suit.
COUNTIF
The above assumes
ytreated asYand cell contents of more than a single character (eg "Yes", "YY", "Say" ...) do not count as contain Y.