Return value based on background color

Hi All

I've got a problem to write macro.
I need users to color code background (manual not conditional formatting) depending of progress in projects.
Then range L6:N10 will automatically return value (from range E5:I5) based on background color.

Users got very basic excel skills and their work will limit to manual background change.

I need something like INDEX MATCH based on colorindex.

Thank you for your help.
Regards
Daniel

I would suggest using 1, 2 and 3 instead of colours as the user input, use conditional formatting if neccessary to make it look like you wish.

This is also quicker for the user than changing background colours.

However, you could use a user-defined-function like:

Please Login or Register  to view this content.

To do what you want, you would need:
=colour_find($E6:$I6,$G$16) in L6
=colour_find($E6:$I6,$G$15) in M6
and
=colour_find($E6:$I6,$G$17) in N6

then copy down as neccessary.

thank you ragulduy, but your function returns "X". I need it to return correct date from range E5:I5 depending of background. Will you be able to help please?