Forum Discussion
Solved
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...
Sorry, I didn't notice that you specified Excel for Web.
Select Formula from the Rule Type drop-down.
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
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