Planner project

Hi, I have set up an excel spreadsheet that colours cells depending in dates and No's entered.

I have attached a copy of the spreadsheet so you can check what error there is.

If you look at the Region 1 worksheet, column 'F' shows the No's as weeks entered and the cells in Rows 7 through to 12 should colour according to column 'F' data.
What is showing is an extra cell being coloured of which I do not know what I have done for this to happen or what formula I should have entered to make it right.

Also I have created a Conditional Format so the Rows show different colours.

Would anyone be able to help me with this.

Many thanks

Pugg

Would anyone please be able to help me with this spreadsheet as I would like to know why every-time I enter a number into column 'F', the Rows should only colour the number of cells column 'F' has been inputted but it always colours and extra cell of which I do not know why.

Many thanks for reading

Pugg

H everyone, I have taken on board all that you have sent to me and found '=IF(I$3>=$G7, IF(I$3<$H7," ", "-"), "-")', from what FDibbins 1st sent works best, as the other 2 sent creates the cells to colour but adds 'True' or 'False' into the cell of which I want the cell to show nothing.

I have added/copied the Region 1 worksheet to the other Tabs so we can start to create a database of projects that will be either 'Approved', 'In Progress', 'Validated' etc.

What I would like now for someone to help with the 'Consolidated' tab where all the other Tabs and the Headers for each tab show the progress as a quick view of where each Project is currently standing.

As an example:
Each Tab will have Design & Launch Date start & finish times for each Project.
The Consolidated Tab shows where each Project is standing.
This can be by creating a quick list of each sector (Design, Detail Design, Procurement, Installation & Launch Date) and showing its progress.
I know each Tab will already show this but the Consolidated tab should have a quick guide from all Projects on each tab.

I was asked if this could be created as a Dashboard of which I was not sure but someone out there would be able to help me verify it can be done OR
Do I go with the simple basics as outlined above.

Would anyone be able to help me further update this sheet.


Pugg

Guys,
Please excuse my blonde moment from not reading the detail you sent.
Yes it does work and I have made changes and updated. What I have done is removed the =n so it reads =AND(I$3>=$G7,I$3<$H7,$F7) and captures just the Row and not the full area, giving me more to work with, thx.

Would you be able to help me understand the Consolidated tab where I can view and read what all the other tabs have done so far without going through each one

Pugg

Is there anyone out there that can guide me or help me with Consolidation of the the spreadsheet tab so it shows start & finish for each timeline of the projects.

Pugg