Conditional Formatting

[Tryingtoresolve]

I am trying to get one cell update another colour E2 contains a dropdown with 2 different statements On Hold and Sales M2 contains the destination figures

On hold I want to add a colour when it's greater than 120
Sales I want to add a different colour for when it's over 30

I can get conditional formatting to work the normal way but not by instructing it with a comment

 

[Joe4]

A "comment"? Where do "comments" come it to play here?

Can you post a sample of your data and expected output?

MrExcel has a tool called “XL2BB” that lets you post samples of your data that will allow us to copy/paste it to our Excel spreadsheets, so we can work with the same copy of data that you are. Instructions on using this tool can be found here: XL2BB Add-in

Note that there is also a "Test Here” forum on this board. This is a place where you can test using this tool (or any other posting techniques that you want to test) before trying to use those tools in your actual posts.

 

[Tryingtoresolve]

I cant download software XL2BB ADDINS as its awork laptop and I only have a phone and I can't seem to get the software to work on my phone

I was hoping someone could give me the formula to resolve the issue

 

[Joe4]

OK, I am then just going to assume that "comment" was an accidental post, and you are not trying to do anything with Excel "Comments" here.

If you want to check for E2 equal to "On Hold" and M2 greater than 120, then your Conditional formatting formula should look like this:

=AND($E2="On Hold",$M2>120)

and then choose your desired color.

If you want a different color when M2 is greater than 30 (but less than or equal to 120), you would use this formuila:

=AND($E2="On Hold",$M2>30,$M2<=120)

and then choose your desired color.

 

[Tryingtoresolve]

OK, I am then just going to assume that "comment" was an accidental post, and you are not trying to do anything with Excel "Comments" here.

If you want to check for E2 equal to "On Hold" and M2 greater than 120, then your Conditional formatting formula should look like this:

=AND($E2="On Hold",$M2>120)

and then choose your desired color.

If you want a different color when M2 is greater than 30 (but less than or equal to 120), you would use this formuila:

=AND($E2="On Hold",$M2>30,$M2<=120)

and then choose your desired color.

Great thank you I will give it a try in the morning