Forum Discussion

EditingElephant's avatar
EditingElephant
Copper Contributor
Apr 26, 2024

Highlighting a part of a row based on 1 cell

Hi all, I know that you can't create a checklist in excel online so I'm trying this as an alternative.

I'd like to highlight columns H to L if the cell in column I contains Y (or YES if needed). Can you help with the exact formula and what cells I need to highlight please?

 

If I need to highlight the whole row instead then I'm happy to do that as an alternative.

 

excel
Excel for web
Formulas and Functions
  • HansVogelaar's avatar
    HansVogelaar
    MVP
    Apr 26, 2024

    EditingElephant 

    Select H7:L16.

    The active cell in the selection should be in row 7 (for example H7).

    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

    =LEFT($I7) = "Y"

    Click Format...
    Activate the Fill tab.
    Select a highlight color.
    Click OK, then click OK again.

    • EditingElephant's avatar
      EditingElephant
      Copper Contributor
      Apr 26, 2024

      HansVogelaar Thank you for your help. One snag though, there's no 'Use a formula to determine which cells to format' option, it only comes up with this