It is possible to colour code a single cell on another sheet by entering date into a different cell
example sheet 1 cell A2 I enter 23 into it
outcome


Sheet 2 cell C32 changes colour to red

Hi Have you tried Conditional Formatting?

__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post

Yes it is possible :-).

Hi
You can use Conditional formatting to do this.
Hope this helps.
Tony

I get the message saying

you cannot use references to other worksheets or workbook for conditional formatting criteria

could it be because I am using excel 2007 not 2010 as I stated ??

I have 13 sheets in this book all with different data in but want to be able to view the activity sheet (last sheet in book ) and see who has played what games without looking at all the sheets

example if Bazzeriom has played 4 out of 6 division 1&2 games(as on division 1&2 sheet) it is show on the activity sheet as per sample

But remember the data moves about on the sheets apart from the activity sheet as they are league tables

hope this helps explains it better

have enclosed a sheet

Any help with this problem please

Have now upgraded to excel 2010

Attached Files

All Sheets Master Plan with data in for example.xlsm (383.8 KB, 13 views)