Tigerexcel
Active Member
- Joined
- Mar 6, 2020
- Messages
- 493
- Office Version
- 365
- 2019
- Platform
- Windows
I have a list with 3 columns, each row is allowed one cell to have a background fill eg yellow. Is there a way to change the particular coloured cell in a row to another column and then have the original cell revert to standard fill background. In this particular exercise I need to ensure that no row has more than one background coloured cell.