conditional formatting in excel 2007
I have a table of 90 rows with names in column 1 followed by 6 cloumns of
numbers. i.e.1 Alan 8 11 23 38 42 48 2 Dave 6 8 13 24 40 43 and so on. Presently I have a CF formula that will colour a number cell Grey when the matching number is entered into a master row. =MATCH(C1,$R$1:$BR$1,0) I now want the name to turn Yellow when 4 numbers are greyed, Red when 5 numbers are greyed and Green when all 6 are greyed. Any ideas please? |
conditional formatting in excel 2007
Assuming the name is in cell B2:
Yellow: =SUMPRODUCT(--ISNUMBER(MATCH(C2:H2,,R$1:BR$1,0)))=4 Red: =SUMPRODUCT(--ISNUMBER(MATCH(C2:H2,,R$1:BR$1,0)))=5 Green: =SUMPRODUCT(--ISNUMBER(MATCH(C2:H2,,R$1:BR$1,0)))=6 -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "Lofty" wrote: I have a table of 90 rows with names in column 1 followed by 6 cloumns of numbers. i.e.1 Alan 8 11 23 38 42 48 2 Dave 6 8 13 24 40 43 and so on. Presently I have a CF formula that will colour a number cell Grey when the matching number is entered into a master row. =MATCH(C1,$R$1:$BR$1,0) I now want the name to turn Yellow when 4 numbers are greyed, Red when 5 numbers are greyed and Green when all 6 are greyed. Any ideas please? |
All times are GMT +1. The time now is 02:11 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com