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
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - Sep 9, 2014 at 11:13 AM
Related:
- Conditional formating of row based on other cells
- Saints row 2 cheats - Guide
- Conditional formatting if two cells match ✓ - Excel Forum
- Excel macro to create new sheet based on value in cells - Guide
- Excel conditional formatting if another cell contains specific text ✓ - Excel Forum
- "Publish your article in rss format for other websites to syndicate" ✓ - Internet & Social Networks Forum
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
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
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
