if/then routines?

[RickyDee]

Good morning. Hope you all had a nice Holiday.

Ok, question: I have this spreadsheet all fixed up for
Football, and my proposed bets. A small example below:
Marshall -17.5 318
Arkansas 9.5 311
Texas 20 315
Arizona 15.5 313

Team Line Number on ticket

Ok, here's the proposal. (I can't write the neat stuff,
so I have to use what EXCEL has to offer from the menus).
Let's say I take Marshall with the -17.5 points. I create
another place on the worksheet with the actual scores.
Now, Marshall wins, but by only 12 points. I type in
the 'new' place on this sheet the actual score of 12
points. Since it's under the set score of 17.5 points, I
want this line to turn RED. Can this be done easily?

Thanks people, and have a wonderful day,
RickyDee

 

[Andy B]

Ricky

Check out Conditional Formatting, in the Format menu. This can do what you
want.

Andy.

 

[Guest]

that did it. This tab opened up a lot of possibilities
for me.

Thanks again, and have a nice day,
RickyDee