bbartlinski
New Member
- Joined
- Jul 26, 2022
- Messages
- 7
- Office Version
- 365
- Platform
- Windows
I need to change the color of a row based on what cell has data in it. I've made multiple conditional formatting rules and it works on one row. How can I apply the rules to the entire sheet based off each individual row...
The orange row has the rule applied but if I copy it to the yellow row it grabs the data from the orange row now the yellow. I dragged it down using the "Fill Formatting only" parameters and did the same thing.
View attachment 70183
The orange row has the rule applied but if I copy it to the yellow row it grabs the data from the orange row now the yellow. I dragged it down using the "Fill Formatting only" parameters and did the same thing.
View attachment 70183