Hi
I want to change the background color of the rows in my Excel worksheet based on the value of a certain column named 'Status'.
Status can have around 7 values Conditional Formatting might not be the right choice. Following are the values that the status column can take
1. Resubmitted
2. Cancelled
3. In Progress
4. Pending
5. Cancelled
6.SignedOff
7.Testing
Each status should be indicated by a unique color for the row. Any help would be highly appreciated
Thanks
Configuration: Windows XP Internet Explorer 6.0
Hi
|