Forum Discussion
RozBloggs
Aug 02, 2020Copper Contributor
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.
I've attached my spreadsheet, which shows which cells should be highlighted for a 'purchase' 'sale' and 'mortgage' Basically I'm trying to create a checklist where I only have to type in the file type, and the irrelevent boxes for that file type are shaded in.
I tried to do rule, which worked well, but only applied the shading to the first cell.
Any help would be greatly appreciated, I've been working on this all day and can't figure it out!