Conditional formating of row based on other cells

Closed
Bitbull Posts 1 Registration date Thursday August 28, 2014 Status Member Last seen August 28, 2014 - Aug 28, 2014 at 09:07 PM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - Sep 9, 2014 at 11:13 AM
Hello,
I am trying to format cells A7-E7 based on the relationship between C6 and C5.
Ideally they would be coloured on a scale between green and yellow if C6 was between C5 and 0 and would be red if C6>C5.
Thanks,

1 response

TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 552
Sep 9, 2014 at 11:13 AM
Hi Bitbull,

Start by selecting A7-E7.

Goto conditional formatting and choose to enter a formula:
=AND(C6>C5,C6<0)
this works if the value in C5 is a negative number, else switch around the greater/smaller then symbols.

Second formula would be:
=C6>C5

Best regards,
Trowa
-1