Conditional formating to check text in another shell + numeric
Solved/Closed
Karthikeyan1207
vcoolio
- Posts
- 18
- Registration date
- Wednesday November 26, 2014
- Status
- Member
- Last seen
- August 3, 2020
vcoolio
- Posts
- 1356
- Registration date
- Thursday July 24, 2014
- Status
- Moderator
- Last seen
- August 11, 2022
Related:
- Conditional formating to check text in another shell + numeric
- Excel conditional formatting if another cell contains specific text ✓ - Forum - Excel
- Conditional formatting excel if another cell contains text ✓ - Forum - Excel
- Conditional formatting if another cell is blank - Forum - Excel
- If cell contains date then conditional format - Guide
- Excel conditional formatting 5 color scale ✓ - Forum - Excel
2 replies
vcoolio
Nov 26, 2014 at 09:13 AM
- Posts
- 1356
- Registration date
- Thursday July 24, 2014
- Status
- Moderator
- Last seen
- August 11, 2022
Nov 26, 2014 at 09:13 AM
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.
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.
Karthikeyan1207
Nov 27, 2014 at 03:50 AM
- Posts
- 18
- Registration date
- Wednesday November 26, 2014
- Status
- Member
- Last seen
- August 3, 2020
Nov 27, 2014 at 03:50 AM
Hi It works, thanks a lot
vcoolio
Nov 27, 2014 at 04:09 AM
- Posts
- 1356
- Registration date
- Thursday July 24, 2014
- Status
- Moderator
- Last seen
- August 11, 2022
Nov 27, 2014 at 04:09 AM
Hi Karthikeyan,
Glad I could help :-)
Glad I could help :-)