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?
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
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.
The above assumes
y treated as
Y and cell contents of more than a single character (eg "Yes", "YY", "Say" ...) do not count as contain Y.