Forum Discussion

NHodg365's avatar
NHodg365
Copper Contributor
Nov 14, 2023
Solved

Conditional formatting with colours

Evening all I have a spreadsheet which I'd like to populate with event details across A-E columns.  Column F contains a drop down options.  Once an item is selected from the drop down, I'd like th...
excel
Formulas and Functions
  • HansVogelaar's avatar
    HansVogelaar
    Nov 14, 2023

    NHodg365 

    Select A9:F200 or however far down you want.

    A9 should be the active cell in the selection.

     

    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

    =$F9="PT"

    Click Format...
    Activate the Fill tab.
    Specify pink as highlight color (Hex #FF7F92).
    Click OK, then click OK again.

     

    Repeat these steps but with the formula

    =$F9="OM"

    and blue (Hex #8EA9DB) as fill color.

     

    Etc. - one rule for each type.

HansVogelaar's avatar
HansVogelaar
MVP
Nov 14, 2023

NHodg365 

Select A9:F200 or however far down you want.

A9 should be the active cell in the selection.

 

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

=$F9="PT"

Click Format...
Activate the Fill tab.
Specify pink as highlight color (Hex #FF7F92).
Click OK, then click OK again.

 

Repeat these steps but with the formula

=$F9="OM"

and blue (Hex #8EA9DB) as fill color.

 

Etc. - one rule for each type.

Resources