Forum Discussion
How to Format AutoFill Options in Excel
Excel does not have a way to do this automatically - you have to create a conditional formatting rule for each value.
Let's say you want to apply this to rows 2 to 100. Select these rows.
The active cell in the selection should be in row 2.
On the Home tab of the ribbon, click Conditional Formatting > New Rule...
Select 'Use a formula to determine which cells to format'.
Enter the formula=$B2=7
Click Format...
Activate the Fill tab.
Select blue as highlight color.
Click OK, then click OK again.Repeat these steps with the formula =$B2=5 and yellow as highlight color.
Etc.
Excel does not have a way to do this automatically - you have to create a conditional formatting rule for each value.
Let's say you want to apply this to rows 2 to 100. Select these rows.
The active cell in the selection should be in row 2.
On the Home tab of the ribbon, click Conditional Formatting > New Rule...
Select 'Use a formula to determine which cells to format'.
Enter the formula
=$B2=7
Click Format...
Activate the Fill tab.
Select blue as highlight color.
Click OK, then click OK again.
Repeat these steps with the formula =$B2=5 and yellow as highlight color.
Etc.
HansVogelaar thank you!