Conditional formating to check text in another shell + numeric [Solved/Closed]

Report
Posts
18
Registration date
Wednesday November 26, 2014
Status
Member
Last seen
August 3, 2020
-
Posts
1269
Registration date
Thursday July 24, 2014
Status
Moderator
Last seen
January 4, 2021
-
I have some text in A column ( say xxx, yyy) and numeric value in Column B . Now i want to highlight the shell in column B with 4 condition .

1. If the text in column A1 is xxx, and the value in B1 is less than 10 , i need Green color fill in B1 2. If the text in column A1 is xxx, and the value in B1 is greater than 10, i need red color fill in B1
3. If the text in column A1 is yyy, and the value in B1 is less than 10, i need red color fill in B1
4. if the text in column A1 is yyy,and the value in B1 is greater than 10,i need green color fill in B1

How to get this done with Conditional formating, pls advice .

2 replies

Posts
1269
Registration date
Thursday July 24, 2014
Status
Moderator
Last seen
January 4, 2021
214
Hello Karthikeyan,

First of all, click on cell B1. Go to the home tab and click on conditional formatting.
Select "New Rule."

In the "New Formatting ' window which opens, select "Use a formula to determine which cells to format."

In the box in which above it says "Format values where this formula is true", place the following formulae (make sure that cell B1 is always highlighted). You will need to repeat these steps for each formula:-

=IF(A1="xxx",B1>10,IF(A1="yyy",B1<10)) then click on the format button below it and select a red colour. Click OK. This will take you back to the "New formatting" box. Click OK again.

*NEW RULE (Follow the same steps as above).

=IF(A1="xxx",B1<10,IF(A1="yyy",B1>10))
then click on the format button below it and select a green colour. Click OK. This will take you back to the "New formatting" box. Click OK again.


Hopefully this is what you were wanting.

Regards,
vcoolio.
Posts
18
Registration date
Wednesday November 26, 2014
Status
Member
Last seen
August 3, 2020
1
Hi It works, thanks a lot
Posts
1269
Registration date
Thursday July 24, 2014
Status
Moderator
Last seen
January 4, 2021
214
Hi Karthikeyan,

Glad I could help :-)

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!