Conditional Formatting

Closed
gelert64 Posts 1 Registration date Wednesday June 24, 2015 Status Member Last seen June 24, 2015 - Jun 24, 2015 at 04:56 AM
Mazzaropi Posts 1985 Registration date Monday August 16, 2010 Status Contributor Last seen May 24, 2023 - Jun 24, 2015 at 07:29 AM
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 response

Mazzaropi Posts 1985 Registration date Monday August 16, 2010 Status Contributor Last seen May 24, 2023 147
Jun 24, 2015 at 07:29 AM
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.
0