RedOctoberKnight
Board Regular
- Joined
- Nov 16, 2015
- Messages
- 150
- Office Version
- 2016
- Platform
- Windows
Good Morning,
I'm looking for a conditional formatting formula that will highlight a specific number of cells across a row based on the value in A1. So for instance, if A1 = 3, then cells B1, C1, and D1 would change to a specific color. If A1 = 5, then B1, C1,D1, E1, and F1 would change.
Any help would be much appreciated. Thanks.
I'm looking for a conditional formatting formula that will highlight a specific number of cells across a row based on the value in A1. So for instance, if A1 = 3, then cells B1, C1, and D1 would change to a specific color. If A1 = 5, then B1, C1,D1, E1, and F1 would change.
Any help would be much appreciated. Thanks.