I have an excel spreadsheet that displays a matrix of % changes for a stock. I want to do a heat map with 12 conditions.
e.g.: 1) if cell value between -1% and 0% then - background color of the cell should be a very light red.
2) if cell value between -2% and -1% then - background color of the cell should be a light red.
This should be a macro that runs every day or on command.
It's as simple as that. Conditional Formatting in excel only allows 3 conditions per cell. I have 12 conditions.
51 freelancers are bidding on average $41 for this job
Hello friend, this can be finished within 1 day. If you think I'm the right person for the job then you are not wrong. Kind regards and (pozdrav if you are from the Balkans).
Hello, Sir. I have done your project requirements as demo. I send you the demo excel file. Pleae look into that and kinldy inform me your view. Thanks. Best regards.