Forum Discussion

Copper Contributor

Aug 02, 2020

Auto Shade Multiple Cells Based on Data in One Cell

I am creating a checklist and need to have multiple cells shaded based on the text in one cell. Each time 'Sale' is typed into any row in column 'F', the same columns are shaded for that row. ...

Checklist.xlsx131 KB

developer

excel

Formulas and Functions

RozBloggs

Copper Contributor

Aug 02, 2020

TheAntony sorry another thing - I need to be able to fill in the unshaded boxes (Y, N, R, or N/A) - but when I do that it gives me an error?

TheAntony

Iron Contributor

Aug 02, 2020

RozBloggs , Didn't know that you wanted to use those cells for typing. I moved the formula into conditional formatting dialog. You should be able to use those cells now.

Checklist.xlsx15 KB

TheAntony
Iron Contributor
Aug 02, 2020
RozBloggs , Happy to help. Enjoy!
RozBloggs
Copper Contributor
Aug 02, 2020
TheAntony Amazing, works perfectly. I can't thank you enough!