Forum Discussion

RozBloggs's avatar
RozBloggs
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.   ...
developer
excel
Formulas and Functions
TheAntony's avatar
TheAntony
Iron Contributor
Aug 02, 2020

RozBloggs , No worries. Here's a version that should work without the latest update. Also, I deleted the empty table rows since they were just taking up space. The nice thing about Excel Tables is that they will expand as you type in new info.

RozBloggs's avatar
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's avatar
    TheAntony
    Iron Contributor
    Aug 02, 2020

    RozBloggs , Happy to help. Enjoy!

  • RozBloggs's avatar
    RozBloggs
    Copper Contributor
    Aug 02, 2020

    TheAntony Amazing, works perfectly.  I can't thank you enough!

  • TheAntony's avatar
    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.

Resources