I have tried understanding other threads that have similar problems with cell's fill color, but for the life of me I just can't understand them so time to get help with people who actually dominate coding and Excel. This is something that looks simple in my mind, I just have no idea how to do it.
Basically, I want Excel to print the values on row 1, if the five cells directly below the cell on row 1 of each collumn have a red fill (fill which was added manually).
This image helps illustrate what I have:
http://img338.imageshack.us/f/excelissue.gif/
There is no conditional formatting and cells have numeric and text values. Only the cells with a specific color fill are important... so something like if cells a2; a3; a4; a5; a6 have a red fill, get a1, move to B column and so on, show all values
Sounds simple at least so using the gif example, upon selecting the first row and running said magic script, Excel would fetch and display "beta, epsilon, and so on<and so="" on="">"
Thank you for any help
Mrs. C
</and>
Basically, I want Excel to print the values on row 1, if the five cells directly below the cell on row 1 of each collumn have a red fill (fill which was added manually).
This image helps illustrate what I have:
http://img338.imageshack.us/f/excelissue.gif/
There is no conditional formatting and cells have numeric and text values. Only the cells with a specific color fill are important... so something like if cells a2; a3; a4; a5; a6 have a red fill, get a1, move to B column and so on, show all values
Sounds simple at least so using the gif example, upon selecting the first row and running said magic script, Excel would fetch and display "beta, epsilon, and so on<and so="" on="">"
Thank you for any help
Mrs. C
</and>