Based on the color of a cell value should be entered in the next cell

[jeevanarivu]

Hello All,

I am trying to get the values entered automatically based on the color of a cell.

Example is attached.

I dont know VBA script writing. So any solution based on VBA need to be more elaborate.
Kindly help me.

Thanks,
Ariv

[humdingaling]

you are using conditional format to determine colour
in that case you can use formula to mirror the conditional format

put this formula in c2 and fill down

Please Login or Register  to view this content.

[jeevanarivu]

Hi humdingaling,

This is working fine..
Thanks for the quick reply.

Best Regards,
Ariv