Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 76
  • Last Modified:

Paint team losses in red.

Hi everyone,

In the attached sheet named '2014-2' are team scores. I would like to automatically color any team losses in red. The attached table has team losses done manually.

Attempted to do this using conditional formatting but was unable. Hope someone can help.

P.S. It should also work when items toward the bottom are updated. (i.e. 213:229).
Team-Loss-in-red.xlsx
0
Pedrov664
Asked:
Pedrov664
  • 3
1 Solution
 
Ejgil HedegaardCommented:
Mark the entire columns B to CM.
In the conditional formatting use this formula
=AND(ROW()>4,OR(AND(ISNUMBER(B1),ISNUMBER(C1),B1<C1),AND(ISNUMBER(B1),ISNUMBER(A1),B1>A1)))
0
 
Pedrov664Author Commented:
Ejbil,

would I have to change the formula cell numbers to match each other cell?

In other words, cell B1 and C1 apply to 'BAL' cells and then E:F apply to 'WSH', etc. or will the format applied to all cells, like you said above, be sufficient when copied across, as you said?
0
 
Pedrov664Author Commented:
Ejbil,

Never mind that last statement.

I tried it and it does work on all cells in range.
0
 
Pedrov664Author Commented:
Good Work!
0

Featured Post

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now