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:
- "Publish your article in rss format for other websites to syndicate"
- Microsoft websites are not opening ✓ - Internet & Social Networks Forum
- How to right a blog? - Internet & Social Networks Forum
- Microsoft Publisher - Software Forum
- Publisher? ✓ - Office Software Forum
- I am Facing Problem in My Redirected Blog site Rss feed - 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