Conditional formatting
Closed
driaswann
Posts
1
Registration date
Monday February 25, 2013
Status
Member
Last seen
February 25, 2013
-
Feb 25, 2013 at 11:03 AM
Zohaib R Posts 2368 Registration date Sunday September 23, 2012 Status Member Last seen December 13, 2018 - Feb 25, 2013 at 12:04 PM
Zohaib R Posts 2368 Registration date Sunday September 23, 2012 Status Member Last seen December 13, 2018 - Feb 25, 2013 at 12:04 PM
Related:
- Conditional formatting
- Excel conditional formatting if another cell contains specific text - Excel Forum
- How to clear formatting in excel - Guide
- To change conditional formatting that applies a red fill color to one that applies a green fill color, which of the following can you do? - Excel Forum
- Excel formula to change cell color without conditional formatting - Excel Forum
- Phone formatting software for pc - Download - File management
2 responses
TrowaD
Posts
2921
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
December 27, 2022
552
Feb 25, 2013 at 11:59 AM
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
Posts
2368
Registration date
Sunday September 23, 2012
Status
Member
Last seen
December 13, 2018
69
Feb 25, 2013 at 12:04 PM
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.
