SOLVED

Highlighting a part of a row based on 1 cell

Copper Contributor

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.

EditingElephant_0-1714141162223.png

 

4 Replies

@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.

@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

 

EditingElephant_0-1714141615311.png

 

best response confirmed by EditingElephant (Copper Contributor)
Solution

@EditingElephant 

Sorry, I didn't notice that you specified Excel for Web.

Select Formula from the Rule Type drop-down.

@HansVogelaar It worked! Thank you very much

1 best response

Accepted Solutions
best response confirmed by EditingElephant (Copper Contributor)
Solution

@EditingElephant 

Sorry, I didn't notice that you specified Excel for Web.

Select Formula from the Rule Type drop-down.

View solution in original post