Conditional formatting
Closed
driaswann
Zohaib R
- Posts
- 1
- Registration date
- Monday February 25, 2013
- Status
- Member
- Last seen
- February 25, 2013
Zohaib R
- Posts
- 2368
- Registration date
- Sunday September 23, 2012
- Status
- Member
- Last seen
- December 13, 2018
Related:
- Conditional formatting
- Conditional formatting if cell does not contain specific text ✓ - Forum - Excel
- Conditional formatting if another cell contains any text ✓ - Forum - Excel
- Excel conditional formatting 5 color scale ✓ - Forum - Excel
- Copy conditional formatting from one row to another ✓ - Forum - Excel
- If cell contains date then conditional format - Guide
2 replies
TrowaD
Feb 25, 2013 at 11:59 AM
- Posts
- 2886
- Registration date
- Sunday September 12, 2010
- Status
- Moderator
- Last seen
- June 27, 2022
Feb 25, 2013 at 11:59 AM
Hi Driaswann,
Strange title.
Sounds to me like you want an IF formula:
=IF(P5>Q5,Q5,IF(P5<Q5,P5,""))
Put this formula in R5.
If P5 equals Q5 then R5 is empty.
Best regards,
Trowa
Strange title.
Sounds to me like you want an IF formula:
=IF(P5>Q5,Q5,IF(P5<Q5,P5,""))
Put this formula in R5.
If P5 equals Q5 then R5 is empty.
Best regards,
Trowa
Zohaib R
Feb 25, 2013 at 12:04 PM
- Posts
- 2368
- Registration date
- Sunday September 23, 2012
- Status
- Member
- Last seen
- December 13, 2018
Feb 25, 2013 at 12:04 PM
Hi driaswann,
You can use nested IFs to get the desired results. Please put the following formula in R5:
=IF(P5>Q5,Q5,IF(P5<Q5,P5,""))
Do reply with results.
You can use nested IFs to get the desired results. Please put the following formula in R5:
=IF(P5>Q5,Q5,IF(P5<Q5,P5,""))
Do reply with results.