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.
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. Read More