Excel sheet automation -- 2
Budget: $10 – $30 USD
We have a small excel sheet project. The current excel sheet needs to be converted to a value-assigned master sheet.
This is how is looks current excel sheet looks - attachment-1
We would like to convert this to an value-assigned excel sheet as seen below attachment-2. The colour of the cell content will decide the values. For e.g.
Yes (in green) --→ Yes, 120,
Yes (in black) --→ Yes, 100,
Yes (in red) --→ Yes, 90,
Yes (in blue) --→ Yes, 95
The font colour will decide the value. We need a designated area for e.g. another excel tab to design the colour rules for e.g. Black = 100, Red = 90, Green = 120, Blue = 95 etc. The admin should be able to change the colour and the value assigned dynamically.
N.B. - The first 3 columns e.g. Sl no, feature code and sub-features column can be ignored and excluded from this formula.
This is how is looks current excel sheet looks - attachment-1
We would like to convert this to an value-assigned excel sheet as seen below attachment-2. The colour of the cell content will decide the values. For e.g.
Yes (in green) --→ Yes, 120,
Yes (in black) --→ Yes, 100,
Yes (in red) --→ Yes, 90,
Yes (in blue) --→ Yes, 95
The font colour will decide the value. We need a designated area for e.g. another excel tab to design the colour rules for e.g. Black = 100, Red = 90, Green = 120, Blue = 95 etc. The admin should be able to change the colour and the value assigned dynamically.
N.B. - The first 3 columns e.g. Sl no, feature code and sub-features column can be ignored and excluded from this formula.