Previous Topic Next Topic

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
Hello,

If cell P5 is greater than Q5, I need cell R5 to equal Q5. If P5 is less than Q5, I need cell R5 to equal P5.

Any help would be appreciated.
Thank you for your time.

:)

2 replies

Answer 1 / 2
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen January 16, 2023 547
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
0
Answer 2 / 2
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
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.
0

Similar discussions

How to use conditional format based on text?
Leanne99 -
Mooseman -

26 responses
Highlight cell if another cell contains any text
LvH -
LvH -

4 responses
Conditional format based on another cell containing text
stakik -
Corrina66 -

5 responses
Highlight cell if another cell contains specific text
Abbi -
vcoolio -

1 response
Conditional formatting with multiple rules and blank text cells
PaiviM -
PaiviM -

6 responses
Condition formatting on changing cell color based on another cel
Saitoh7 -
Mazzaropi -

1 response