Hello there,

Please help! I have coloured certain numbers either blue or red. My
spreadsheet is as follows:
Column
A B C D E
Row1 12 30 17 25 2
Row2 32 18 4 11 41
Row3 3 26 19 39 12
Row4 27 19 21 3 16
Row5

I want to populate Row5 with values and I need Excel to look at each cell
and do the following:
- eg. Identify the column/s with no coloured number
- When this column/s is found, take the respective values in Row4 of the
column and populate Row5 cells from left to right.

Thanx for your help!
--
KCG