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

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

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

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

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