Forum Discussion
Copy values to a cell based on color
Hello I need help,
Column A ( file attached) has some blank cells with colors inside them.
I need to fill them with values, based on color matching from adjacent columns
2 Replies
Lost_inExcel No need to use those colors. I inserted two columns, D and E. Column D calculates how many consecutive empty cells there are in column A. Column E then fetches the correct value from the table with colors based on the number of empty rows.
- Thank you!, your solution works!
