Forum Discussion

ebkay82's avatar
ebkay82
Copper Contributor
Jan 25, 2024
Solved

How to Format AutoFill Options in Excel

I'm looking for a way to auto fill (highlight) the entire row a particular color based on the value entered in a cell on that line. For instance, I want every row highlighted blue where there's a num...
  • HansVogelaar's avatar
    Jan 25, 2024

    ebkay82 

    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.

Resources