Welsh Mark3
Board Regular
- Joined
- Apr 7, 2014
- Messages
- 164
- Office Version
- 365
I'm creating a sales dashboard that uses Conditional Formatting. My columns range from E - P Jan through December. Row 2 = sales target and row 3 = Sales Result.
I'm trying to use Conditional Formatting formatting so that if cell e2 is greater than e3 the cell is highlighted green. My question is do I need to use a conditional formating rule for 12 cells for each month? Or is there a shortcut / function that can help?
I'm trying to use Conditional Formatting formatting so that if cell e2 is greater than e3 the cell is highlighted green. My question is do I need to use a conditional formating rule for 12 cells for each month? Or is there a shortcut / function that can help?