Forum Discussion
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. ...
TheAntony on the right track! But when I type in Sale now, all the shading disappears, and then if I delete/change them it all disappears again... 😞
RozBloggs , Here's how I set it up to work (see attached video). Is this not what you were looking for? Can you share a screenshot or video of what it looks on your computer?
TheAntony Your video works perfect - that's exactly what I'm looking for! I'm not sure why it doesn't work on the downloaded one?
When I open it it looks great:
If I delete one item in the column it deletes all the shading:
And when I add a new item to the column it doesn't add the shading: