Forum Discussion
Formatting Consecutive Wins and Losses
I am looking to change the font color of entries within a profit / loss spreadsheet if there are consecutive wins or losses. I would like consecutive wins (W) to have green font and consecutive loss...
Select B2:P2.
On the Home tab of the ribbon, click Conditional Formatting > New Rule...
Select 'Use a formula to determine which cells to format'.
Enter the formula
=AND(B2="W",OR(A2="W",C2="W"))
Click Format...
Select green as font color.
Click OK, then click OK again.
Repeat the above steps, but with
=AND(B2="L",OR(A2="L",C2="L"))
and red as font color.