Hi All -
I have a spreadsheet which is based on the english premier league.
In cell C4 and E4 is where I type in the scores for Team 1 (Arsenal) and I paste this formula into F4 with some conditional formatting
<tbody>
</tbody>
Conditional Formatting:
if cell is "WIN" colour is green
if cell is "DRAW" colour is yellow
if cell is "LOSE" colour is red
My problem I have is when I repeat the above process for cells C5 and E5 I would like the W/D/L in F5 to appear automatically which it used to do - but now it doesn't??? i've looked at using the fill option and the auto fill drop down box but I have no idea what I have done to stop this from working.
With playing around with it whilst I write this thread I did get it to work again - but now it doesn't for a second time
** any ideas welcome **
I will update if I accidentally fix it
I have a spreadsheet which is based on the english premier league.
In cell C4 and E4 is where I type in the scores for Team 1 (Arsenal) and I paste this formula into F4 with some conditional formatting
<e4,"lose",if(c4=e4,"draw")))< td=""></e4,"lose",if(c4=e4,"draw")))<>=IF(C4>E4,"WIN",IF(C4<E4,"LOSE",IF(C4=E4,"DRAW")))<e4,"lose",if(c4=e4,"draw")))< td=""></e4,"lose",if(c4=e4,"draw")))<> |
<tbody>
</tbody>
Conditional Formatting:
if cell is "WIN" colour is green
if cell is "DRAW" colour is yellow
if cell is "LOSE" colour is red
My problem I have is when I repeat the above process for cells C5 and E5 I would like the W/D/L in F5 to appear automatically which it used to do - but now it doesn't??? i've looked at using the fill option and the auto fill drop down box but I have no idea what I have done to stop this from working.
With playing around with it whilst I write this thread I did get it to work again - but now it doesn't for a second time
** any ideas welcome **
I will update if I accidentally fix it
Last edited: