Mark cell with a color based on 2 values setup in a text with a signin between
Hello,
If somebody like to solve a challange (and make me happy)
I've got a sheet with several columns and rows.
A system output shows were the data is changed with the shown combi of "old - new". If the data is changed from empty to something of from something to empty then it shows '-'
The format is always the same
For example;
200,000 - 210,7
'-' - 200
202,1 - '-'
150 - 140
What is the question... (challange);
I need to mark the cell;
red = if the value right = higher then the value left side (200,000 - 210,7).
green = if the value right = lower then the value left side (150 - 140).
bleu = if there was a value left side but now right it is '-' (202,1 - '-').
orange = if there was '-' left and now right side it is a value ('-' - 200)
no coloring if the cell is empty of left/right is identical.
This macro must run for the columns B till D and K till Z
Excel is allways a challange (and certainly the data somebody can prepare)
regard, Johan
|