mclambchop
New Member
- Joined
- Apr 29, 2014
- Messages
- 24
- Office Version
- 365
- Platform
- Windows
Hello,
I have a spreadsheet with two columns, one has an area name in and the second column has the branch name. Some areas could have 5 branches and some could have 15 branches. I would like to format each row based on the area name. So if its area 1 then say a light grey, if area 2 then a light blue, if area 3 revert back to a light grey, area 4 revert back to light blue and so on.
Does anyone have any idea on the best way to do this?
I have a spreadsheet with two columns, one has an area name in and the second column has the branch name. Some areas could have 5 branches and some could have 15 branches. I would like to format each row based on the area name. So if its area 1 then say a light grey, if area 2 then a light blue, if area 3 revert back to a light grey, area 4 revert back to light blue and so on.
Does anyone have any idea on the best way to do this?