Soldato
In an empty cell, I want it to show a number if the cell above it is a certain text. eg
I have 3 colours (in text not actual colours), Green, yellow and red. One of these colours is in a cell. Each colour has to have a value, Green is 2 yellow is 3 and red is 5
the cell with the colour in it is randomly selected out of the 3 each time F9 is pressed. I want a cell to change the number depending on what colour is in the cell above,
In my head its like this:
if cell x is green put a 2 in this one.
I hope this makes sense, I am not that clued up on excel tbh.
thanks in advance
I have 3 colours (in text not actual colours), Green, yellow and red. One of these colours is in a cell. Each colour has to have a value, Green is 2 yellow is 3 and red is 5
the cell with the colour in it is randomly selected out of the 3 each time F9 is pressed. I want a cell to change the number depending on what colour is in the cell above,
In my head its like this:
if cell x is green put a 2 in this one.
I hope this makes sense, I am not that clued up on excel tbh.
thanks in advance