tattslotto spread sheet

Grahamscown

New Member
Joined
Feb 26, 2014
Messages
39
Office Version
  1. 365
  2. 2016
Platform
  1. Windows
  2. Mobile
I have a spreadsheet columns A to J and rows 1 to 250 that contain the syndicate data and cells N2 to U2 that i will input the weekly drawn 6 numbers and 2 supps
1I need the numbers in columns C to H to turn green for the weekly drawn numbers and blue for the supps entered entered into cells N2 to U2 Im not sure how to upload the file so i will upload an image of the spread sheet
 

Attachments

  • sample.png
    sample.png
    133.4 KB · Views: 23

Excel Facts

Can a formula spear through sheets?
Use =SUM(January:December!E7) to sum E7 on all of the sheets from January through December
Do a little research into using conditional formatting.
 
Upvote 0
Hi sorry but not knowing much about the subject or the terminology makes it very hard I cant use duplicate values because it highlights every cell I need the cells IN COLUMNS C TO H to highlight only when the numbers are entered into N2 TO U2
 
Upvote 0
It is hard to work with a picture. It would be easier to help if you could use the XL2BB add-in (icon in the menu) to attach a screenshot (not a picture) of your sheet. Alternately, you could upload a copy of your file to a free site such as www.box.com or www.dropbox.com. Once you do that, mark it for 'Sharing' and you will be given a link to the file that you can post here. Explain in detail what you want to do referring to specific cells, rows, columns and sheets using a few examples from your data (de-sensitized if necessary).
 
Upvote 0
Select the range from C2:H70 and use the following formulas in your conditional formatting:
blue:
Excel Formula:
=OR(C2=$T$2,C2=$U$2)
green:
Excel Formula:
=OR(C2=$N$2,C2=$O$2,C2=$P$2,C2=$Q$2,C2=$R$2,C2=$S$2)
You have to of course select the fill colour for each one.
 
Upvote 1
Select the range from C2:H70 and use the following formulas in your conditional formatting:
blue:
Excel Formula:
=OR(C2=$T$2,C2=$U$2)
green:
Excel Formula:
=OR(C2=$N$2,C2=$O$2,C2=$P$2,C2=$Q$2,C2=$R$2,C2=$S$2)
You have to of course select the fill colour for each one.
Thankyou i was nervous about trying your fix first but found it easy enough to do and very understandable and most of all it worked exactly as i wanted it to Thankyou again
 
Upvote 0

Forum statistics

Threads
1,223,227
Messages
6,170,849
Members
452,361
Latest member
d3ad3y3

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top