Can someone help me highlight columns A to AR grey, in individual rows, if I type '/ into column B?
I found a some instructions online using conditonal formatting, but I can't make it work 😪
Highlight some cells in a row automatically
ExcelHelpPlease · 14/03/2023 15:14
This reply has been withdrawn
This message has been withdrawn at the poster's request
Namechangingagain111 · 14/03/2023 15:36
This helped me:
I think you need to select all the cells that you want to conditionally format, then put this into the formula
good luck !
MrsBennetsPoorNerves · 14/03/2023 15:39
Don't go into that bit where you have to create a new rule. Use the "highlight cells rules" option at the top.
If you don't want the whole row, just highlight all of the cells that you want the rule to apply to.
To comment on this thread you need to create a Mumsnet account.