Previous Topic Next Topic

Conditional formatting

Closed
driaswann Posts 1 Registration date Monday 25 February 2013 Status Member Last seen 25 February 2013 - 25 Feb 2013 à 11:03
Zohaib R Posts 2368 Registration date Sunday 23 September 2012 Status Member Last seen 13 December 2018 - 25 Feb 2013 à 12:04
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 responses

Réponse 1 / 2
TrowaD Posts 2921 Registration date Sunday 12 September 2010 Status Contributor Last seen 27 December 2022 555
25 Feb 2013 à 11:59
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
Réponse 2 / 2
Zohaib R Posts 2368 Registration date Sunday 23 September 2012 Status Member Last seen 13 December 2018 69
25 Feb 2013 à 12:04
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.

Similar discussions

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

1 response
Conditional Format Cells Based on Another Cell and Own Cell
Elaine -
x -

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

26 responses
Conditional formatting based text in another cell
y88y -
y88y -

2 responses
Conditional formatting several cells risk register
oyvinols -
fdibbins -

1 response