LaurenHancy
Board Regular
- Joined
- Aug 5, 2010
- Messages
- 179
Hi All,
In need for some urgent help.
I have figured out how to SumConditionColorCells condional formatting cells. I am summing each working day for each month for 13 different names with 5 different conditional format rules. The only way this will work, is if the conditional formatting is referncing the same cells (Jan 01/01-31/01) that I am trying to sum (Jan 01/01-31/01). I saw a video that somebody conditional formatted 1 row and then highlighted that row to the adjencent rows, this caused new conditional formatting rules to be created. My excel wont let me do this even after removing $!!
This is my conditional formatt rule for January, person 1:
(Person 1, ROW 7) =AND(C9="EL",C9<>"") ------- Applies to =$C$7:$Y$7
When I click the paint brush and paste to other rowns, the formula doesnt change, it just adds to the applies to box like the below:
(Person 2, ROW 11) =AND(C9="EL",C9<>"") --------Applies to =$C$7:$Y$7, $C$11:$Y$11
(Person 3, ROW 15) =AND(C9="EL",C9<>"") ------ Applies to =$C$7:$Y$7, $C$11:$Y$11, $C$15:$Y$15
And so on...
I need my conditional formatting to be:
(Person 2, ROW 11) =AND(C11="EL",C11<>"") --------Applies to =$C$11:$Y$11
Why does my conditional formatting now change rule locations and applies to only selected rows? I have 5 different formatting rules for each row, this means, for each person, on each month, I will have to manually add 780 new conditional format rules for my formual to apply with my UDA code. OMG
This is my formula to average the coloured green cells with time values:
=SumConditionColorCells(C7:Y7,JD4)/COUNTConditionColorCells(C7:Y7,JD4)
I have already completed 1 full row for 12 months for 1 person, this has taken me all night!!
Thank you for your help.
Lauren
In need for some urgent help.
I have figured out how to SumConditionColorCells condional formatting cells. I am summing each working day for each month for 13 different names with 5 different conditional format rules. The only way this will work, is if the conditional formatting is referncing the same cells (Jan 01/01-31/01) that I am trying to sum (Jan 01/01-31/01). I saw a video that somebody conditional formatted 1 row and then highlighted that row to the adjencent rows, this caused new conditional formatting rules to be created. My excel wont let me do this even after removing $!!
This is my conditional formatt rule for January, person 1:
(Person 1, ROW 7) =AND(C9="EL",C9<>"") ------- Applies to =$C$7:$Y$7
When I click the paint brush and paste to other rowns, the formula doesnt change, it just adds to the applies to box like the below:
(Person 2, ROW 11) =AND(C9="EL",C9<>"") --------Applies to =$C$7:$Y$7, $C$11:$Y$11
(Person 3, ROW 15) =AND(C9="EL",C9<>"") ------ Applies to =$C$7:$Y$7, $C$11:$Y$11, $C$15:$Y$15
And so on...
I need my conditional formatting to be:
(Person 2, ROW 11) =AND(C11="EL",C11<>"") --------Applies to =$C$11:$Y$11
Why does my conditional formatting now change rule locations and applies to only selected rows? I have 5 different formatting rules for each row, this means, for each person, on each month, I will have to manually add 780 new conditional format rules for my formual to apply with my UDA code. OMG
This is my formula to average the coloured green cells with time values:
=SumConditionColorCells(C7:Y7,JD4)/COUNTConditionColorCells(C7:Y7,JD4)
I have already completed 1 full row for 12 months for 1 person, this has taken me all night!!
Thank you for your help.
Lauren
