Forum Discussion
Automatically highlight rows based off a number in a cell.
Hello, I would like to have rows automatically highlighted based on a number in a cell. For example, Cell I3 has the number 15. I would like for 15 cells in a row to be highlighted green starting a...
I'm not sure if this is entirely possible so that's why i'm here!
It's possible.
But you would help us help you if (1) you would clarify the rules you want applied
- Cell I3 has the number 15. I would like for 15 cells in a row to be highlighted green starting at today's calendar week.
- I would like to do red 0-4, yellow 4-8, and green 8+.
The green for 8+ is consistent with your desire for the 15
But what do you want for the values 4 and 8? You ascribe them to two different colors.
The second thing you could do to help us help you is to post a copy of the spreadsheet behind the image you posted. To have the actual conditional formatting formula that is applicable to your spreadsheet, we'd need to know how you have coded those calendar week headings. So please post a copy of the spreadsheet on OneDrive or GoogleDrive with a link pasted here that grants access.