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...
  • HansVogelaar's avatar
    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