Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
networkdays and conditional formating
With help and guidance from this site I have created a gant chart and which
will change the colour of each cell depending upon activity duration or % of activity that has been completed, and it works well€¦€¦ however how do I change the formulas to take into account a 5 day week ie Monday to Friday The formulas I have are :- =AND(J$2=$B4,J$2<$B4+$G4) =AND(J$2=$B4,J$2<=$B4+$D4-1) Where J2 = day B4 = start date G4 = activity days completed D4 = activity duration thanks |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
networkdays and conditional formating
=AND(J$2=$B4,NETWORKDAYS($B4,J$2)<$G4)
=AND(J$2=$B4,NETWORKDAYS($B4,$J2)<=$D4-1) -- --- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Suddes" wrote in message ... With help and guidance from this site I have created a gant chart and which will change the colour of each cell depending upon activity duration or % of activity that has been completed, and it works well.. however how do I change the formulas to take into account a 5 day week ie Monday to Friday The formulas I have are :- =AND(J$2=$B4,J$2<$B4+$G4) =AND(J$2=$B4,J$2<=$B4+$D4-1) Where J2 = day B4 = start date G4 = activity days completed D4 = activity duration thanks |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
networkdays and conditional formating
Sorry Bob, but this didnt work it returned a message of "you may not use
references to other worksheets or workbooks for conditional formatting criteria" ! any ideas why this would be the case thank you "Bob Phillips" wrote: =AND(J$2=$B4,NETWORKDAYS($B4,J$2)<$G4) =AND(J$2=$B4,NETWORKDAYS($B4,$J2)<=$D4-1) -- --- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Suddes" wrote in message ... With help and guidance from this site I have created a gant chart and which will change the colour of each cell depending upon activity duration or % of activity that has been completed, and it works well.. however how do I change the formulas to take into account a 5 day week ie Monday to Friday The formulas I have are :- =AND(J$2=$B4,J$2<$B4+$G4) =AND(J$2=$B4,J$2<=$B4+$D4-1) Where J2 = day B4 = start date G4 = activity days completed D4 = activity duration thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditional Formating IS: Help With ANY VALUE | Excel Discussion (Misc queries) | |||
Conditional Formatting with NETWORKDAYS function | Excel Discussion (Misc queries) | |||
Install dates formating using conditional formating? | Excel Discussion (Misc queries) | |||
Conditional formating | Excel Worksheet Functions | |||
Conditional Formating | Excel Discussion (Misc queries) |