Previous Topic Next Topic

Higlight formel (Rewhrite)

Closed
Alstrom - Jan 7, 2011 at 12:40 PM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Feb 9, 2011 at 05:08 PM
Hello, all

English is not my first nor my second laungish, so please excuse me for any miss spelling and gramma errors.

Im looking for a Formel abel to detect if a row of cells are green and reply by making a check cell green as well..

eks. i have 9 cells in a row witch induvidial turn green if sertain critiria is meet and want a check cell to turn green if all the sells are positive (Green).

It cant be based on the number value and critiers of the 9 cells due to a constant change in the critrias..

I was thinking something like and IF form (if cell 1,2,3,4,5,6,7,8,9 are green - Make cell 10 green) but dont know how to write it..


So my question is: Is there a formel solo based on the coloring of the cells?

I would be very gratefull if any one could help me with this..
Ps. my excel expirence is a little limited, so please eksplane it with big letter...

Thank you for your time

Alstrom




1 response

Answer 1 / 1
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
Feb 9, 2011 at 05:08 PM
Could you please upload a sample EXCEL file WITH sample data, macro, formula , conditional formatting etc on some shared site like https://authentification.site , http://docs.google.com, http://wikisend.com/ , http://www.editgrid.com etc
AND post back here the link to allow better understanding of how it is now and how you foresee. Based on the sample book, could you re-explain your problem too.


Note: your data need not be to be real data but a good representative of how data looks like
0