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. ...
RozBloggs , something like this?
ps: I've used the Filter function that is new to the Excel 365 version. Let me know if you are using an earlier version of Excel.
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... 😞