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.
50 freelancers are bidding on average $42 for this job
Hi, I have read the specifications and it's a quite easy work. Please give me an opportunity to work on this project. A quality work within time is guaranteed. Regards alishanuj
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.
Dear Sir, I can create a desktop program runnable under Windows OS what will format you Excel cells based on your criteria. A Program could be set up to run periodically. Yours faithfully, Marian Morzol
Hi, I have vast experience in writing Excel VBA macros. I can provide you a command button, by which on clicking it will provide you the desired results. Regards, Shivkumar Aiyappan
This Job can be done without problem. I have already done more complicated work before for a FreeLancer Customer. You can see my review from that Customer. Allow me to serve you too.
Hi, In Excel 2003, we can use the Macro to do the conditional formatting at anuy number of times. Please check the PMB for the [login to view URL] 10+ years expereince VB and Excel Macros. Thank you, Senthil