Conditional Formatting based on a value in another cell

Question

Hi,

I would like to add conditional formatting to one cell based on the value of another. I have the following formula but it doesn't seem to be working.

="IF($M$3:$M$23=""Declined"")"

I'm using the web version of 365, so wondering if that has something to do with it?

FYI I want to format a strike the contents in Column B based on the content of Column M (Declined or Successful).

Any help is greatly appreciated.

Thanks

Holly

Answer 1

Dear respected BPCfundraising,

Good day! Thank you for posting to Microsoft Community. We are happy to help you.

As per your description, in Excel for web, first, select the range in Column B that you want to format (e.g., B3:B23).

Enter the following formula =($M3="Declined")

Repeat for Successful: If you also want to format based on "Successful," repeat the steps above but change the formula to:

=($M3="Successful")

If there is any misunderstanding, I apologize and could you please send copy of your document file to me so that I can look from my side, and I will check this behavior and help you to fix and verify the result with you.

If there is confidential information, then you can send it to me in Private Message(PM). you can access PM from the top right corner of this page, as shown in image below:

Please understand that our initial reply may not always immediately resolve the issue. However, with your help and more detailed information, we can work together to find a solution.

I'm sorry and I apologize for that.

Appreciate your patience and understanding and thank you for your time and cooperation.

Sincerely,

Waqas Muhammad

Answer 2

Hi respected BPCfundraising,

Thanks for your valuable feedback and I appreciate your kind words.

Also, if you find our suggestions helpful, you can also use the feedback tool below our reply to submit your feedback for us (pictured below).

If there is any issue related with the Office applications in the future, please feel free to post back in this community.

We will be here for help.

Have a good day and stay safe 😊

Best wishes

Waqas Muhammad

Answer 3

Assuming that you select B3:B23 and that B3 is the active cell in the selection, use

=$M3="Declined"

Answer 4

It worked. Thank you.

Answer 5

Amazing! Thank you!