Share via

Excel - Conditional Formatting with multiple string values

Anonymous
2022-10-03T07:47:52+00:00

I want to format cells based on their cell values. While the cells many values, my aim to format the cell color only if the values are either EL or FL, HL or SL. Is this possible in one single go ?

Microsoft 365 and Office | Excel | For business | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

Answer accepted by question author

Anonymous
2022-10-03T08:45:52+00:00

Dear Manjunath Rao,

Thanks for posting in Microsoft community.

If I understand your requirement correctly, you want to fill the cells with conditional formatting when the cell value is EL/FL/HL/SL.

Please check the screenshot below:

If the method couldn't meet your requirement, please post back and I will help you figure out.

Your understanding and patience will be highly appreciated. I hope that you are keeping safe and well!

Sincerely,

Sean Cai | Microsoft Community Moderator

Was this answer helpful?

0 comments

0 additional answers

Sort by: Most helpful
Most helpful Newest Oldest