valeriya290793
New Member
- Joined
- Oct 2, 2020
- Messages
- 1
- Office Version
- 2016
- Platform
- Windows
Ideally what I want is create a complex set of rules for color conditional formatting (basic - from red to green)
The problem is that I have different values for each category (I have one letter category, year category, yes-or-no category) - I want to combine all this data to analyze for conditional formatting
Let's say, for one row Company 1 has PE letter category (good), year 2001 (good), 2 rows with Yes (good) - the row shows green
Row 2, Company 2 has letter category IM (so-so), year 2001 (good), 2 rows yes (good) - the row shows greenish-yellowish
Etc...
Anyone can help how to do that???
The problem is that I have different values for each category (I have one letter category, year category, yes-or-no category) - I want to combine all this data to analyze for conditional formatting
Let's say, for one row Company 1 has PE letter category (good), year 2001 (good), 2 rows with Yes (good) - the row shows green
Row 2, Company 2 has letter category IM (so-so), year 2001 (good), 2 rows yes (good) - the row shows greenish-yellowish
Etc...
Anyone can help how to do that???