Conditional Formatting

Closed
Report
Posts
1
Registration date
Wednesday June 24, 2015
Status
Member
Last seen
June 24, 2015
-
Posts
1947
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
November 11, 2021
-
Hello,
I have created an excel database with all of the football games I have been too. In one column I have the home score and the next the away score i.e 1.0, 2,2, 0,2 etc
I have created a conditional format so that the colour changes to reflect home win, away win or draw. What I would like to know is how to do it over the complete range of vertical scores. How do I replicate that formatting option over many results.
Thanks in anticipation.

RIchard



1 reply

Posts
1947
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
November 11, 2021
147
gelert64, Good morning.

Modify at Menu format the area where you want to apply your rules.
Pay attention about your references to cells.
Sometimes is necessary block ($) some references.
I don't know your specific case.

If necessary save your file at a free site, www.speedyshare.com and put a link to download here.