Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Conditional Formatting
I have a table that I have established conditional formatting in rows that
when the rule is met, colours the cell in that row green. I would also like run some conditional formatting on the columns that says "if the nominated cells are coloured green, then make the header cell yellow". I don't know if this can be done but any assistance would be greatly appreciated. thanks |
#2
|
|||
|
|||
Conditional Formatting
Click on the header cell, and duplicate the conditions that you created to
turn the cell red. -- HTH, RD ============================================== Please keep all correspondence within the Group, so all may benefit! ============================================== "BrisvegasAndy" wrote in message ... I have a table that I have established conditional formatting in rows that when the rule is met, colours the cell in that row green. I would also like run some conditional formatting on the columns that says "if the nominated cells are coloured green, then make the header cell yellow". I don't know if this can be done but any assistance would be greatly appreciated. thanks |
#3
|
|||
|
|||
Conditional Formatting
Mmm, perhaps I didn't explain the problem fully. Here goes. I have a table
which is a matrix of tick boxes (cells). Each row relates to an educational competency and each column is a vocation (comprising a number of competencies/ticks). As a candidate achieves a competency (row) i have established conditional formatting to turn that row green. What I am now attempting to do is to highlight the vocation(column) by means of a colour when all the competencies that make it up are achieved (ie green). So I'm now trying to find a formula that "turns A1 to red when A2, A4, A5, A7 .... are green, but not if they are not green" Hope this makes sense. Thanks "RagDyer" wrote: Click on the header cell, and duplicate the conditions that you created to turn the cell red. -- HTH, RD ============================================== Please keep all correspondence within the Group, so all may benefit! ============================================== "BrisvegasAndy" wrote in message ... I have a table that I have established conditional formatting in rows that when the rule is met, colours the cell in that row green. I would also like run some conditional formatting on the columns that says "if the nominated cells are coloured green, then make the header cell yellow". I don't know if this can be done but any assistance would be greatly appreciated. thanks |
#4
|
|||
|
|||
Conditional Formatting
Hi Andy
You need to take each of the conditions that turn A2,A4,A5 and A7 to Red and join them with an AND() as the condition for your Green =AND(A2cond,A4cond,A5cond,A7cond) Regards Roger Govier BrisvegasAndy wrote: Mmm, perhaps I didn't explain the problem fully. Here goes. I have a table which is a matrix of tick boxes (cells). Each row relates to an educational competency and each column is a vocation (comprising a number of competencies/ticks). As a candidate achieves a competency (row) i have established conditional formatting to turn that row green. What I am now attempting to do is to highlight the vocation(column) by means of a colour when all the competencies that make it up are achieved (ie green). So I'm now trying to find a formula that "turns A1 to red when A2, A4, A5, A7 .... are green, but not if they are not green" Hope this makes sense. Thanks "RagDyer" wrote: Click on the header cell, and duplicate the conditions that you created to turn the cell red. -- HTH, RD ============================================== Please keep all correspondence within the Group, so all may benefit! ============================================== "BrisvegasAndy" wrote in message ... I have a table that I have established conditional formatting in rows that when the rule is met, colours the cell in that row green. I would also like run some conditional formatting on the columns that says "if the nominated cells are coloured green, then make the header cell yellow". I don't know if this can be done but any assistance would be greatly appreciated. thanks |
#5
|
|||
|
|||
Conditional Formatting
Many thanks Roger and RagDyer. Works a treat. Simple when you know how, eh?
Cheers BrisvegasAndy "Roger Govier" wrote: Hi Andy You need to take each of the conditions that turn A2,A4,A5 and A7 to Red and join them with an AND() as the condition for your Green =AND(A2cond,A4cond,A5cond,A7cond) Regards Roger Govier BrisvegasAndy wrote: Mmm, perhaps I didn't explain the problem fully. Here goes. I have a table which is a matrix of tick boxes (cells). Each row relates to an educational competency and each column is a vocation (comprising a number of competencies/ticks). As a candidate achieves a competency (row) i have established conditional formatting to turn that row green. What I am now attempting to do is to highlight the vocation(column) by means of a colour when all the competencies that make it up are achieved (ie green). So I'm now trying to find a formula that "turns A1 to red when A2, A4, A5, A7 .... are green, but not if they are not green" Hope this makes sense. Thanks "RagDyer" wrote: Click on the header cell, and duplicate the conditions that you created to turn the cell red. -- HTH, RD ============================================== Please keep all correspondence within the Group, so all may benefit! ============================================== "BrisvegasAndy" wrote in message ... I have a table that I have established conditional formatting in rows that when the rule is met, colours the cell in that row green. I would also like run some conditional formatting on the columns that says "if the nominated cells are coloured green, then make the header cell yellow". I don't know if this can be done but any assistance would be greatly appreciated. thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditional Formatting Error | Excel Worksheet Functions | |||
difficulty with conditional formatting | Excel Discussion (Misc queries) | |||
conditional formatting question | Excel Discussion (Misc queries) | |||
Determine cells that drive conditional formatting? | Excel Discussion (Misc queries) | |||
Conditional formatting not available in Excel | Excel Discussion (Misc queries) |