Hi there, I have a relatively simple project (I have effectively been asked to turn an MS Excel spreadsheet into an MS Project one because...
)
sheet 1 named "Schedule" will have various bits of data in
In sheet2 named "Graphical" I have the following
B1:BMP1, Merged cells showing Month and Year (mm-yy) I have had to merge these cells manually and any way of doing it automatically so you can just input a start date would be appreciated but is not necessary)
B2:BMP2, Dates, stored as values rather than formulae at the moment but that can be altered. (currently from 1st Aug 2011 to 31st March 2016)
A2: A title of the units of the project (Currently Units) from Cell A1 of Schedule.
A3:A502 currently numbers 1-500 representing the units of the project but could in the future be titles, from cell A2:A501 of Schedule.
What I am loooking to do is use conditional formatting to put;
thin vertical lines between all Sunday's and Mondays (Conditional formatting =WEEKDAY(B$2,3)=6 thin line right)
Medium thickness lines between months (=MONTH(B$2)<>MONTH(C$2) currently red line right)
Thick lines between March and April for financial year (=AND(MONTH(B$2)=3, DAY(B$2)=31)=TRUE() currently blue line right)
I know conditional formatting cannot do line thicknesses and when I tried to use macros ALL my lines went full thickness. Any thoughts would be appreciated.
Just for note in case it changes the tactic. This sheet is intended to have B3:BMP502 a nested if formula from Schedule to identify cells which fall between certain dates at certain stages ie. Order, Purchase, apply, maintenance etc. etc.
These cells will then be conditionally formatted to specific colours to identify each stage of the process, for each unit, by date.
)sheet 1 named "Schedule" will have various bits of data in
In sheet2 named "Graphical" I have the following
B1:BMP1, Merged cells showing Month and Year (mm-yy) I have had to merge these cells manually and any way of doing it automatically so you can just input a start date would be appreciated but is not necessary)
B2:BMP2, Dates, stored as values rather than formulae at the moment but that can be altered. (currently from 1st Aug 2011 to 31st March 2016)
A2: A title of the units of the project (Currently Units) from Cell A1 of Schedule.
A3:A502 currently numbers 1-500 representing the units of the project but could in the future be titles, from cell A2:A501 of Schedule.
What I am loooking to do is use conditional formatting to put;
thin vertical lines between all Sunday's and Mondays (Conditional formatting =WEEKDAY(B$2,3)=6 thin line right)
Medium thickness lines between months (=MONTH(B$2)<>MONTH(C$2) currently red line right)
Thick lines between March and April for financial year (=AND(MONTH(B$2)=3, DAY(B$2)=31)=TRUE() currently blue line right)
I know conditional formatting cannot do line thicknesses and when I tried to use macros ALL my lines went full thickness. Any thoughts would be appreciated.
Just for note in case it changes the tactic. This sheet is intended to have B3:BMP502 a nested if formula from Schedule to identify cells which fall between certain dates at certain stages ie. Order, Purchase, apply, maintenance etc. etc.
These cells will then be conditionally formatted to specific colours to identify each stage of the process, for each unit, by date.
