Brian from Maui
MrExcel MVP
- Joined
- Feb 16, 2002
- Messages
- 8,459
Aloha,
Can anyone write a code that highlights a row a different color. As an example. Range is A2:K100. If A2="Criteria 1" color A2:K2 green. If A2="Criteria 2" color A2:K2 yellow...etc etc.
TIA
Can anyone write a code that highlights a row a different color. As an example. Range is A2:K100. If A2="Criteria 1" color A2:K2 green. If A2="Criteria 2" color A2:K2 yellow...etc etc.
TIA