Closed

Excel Conditional Formatting 12 conditions (easy)

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.

Thanks

Skills: Excel, Visual Basic

See more: excel conditional formatting, macro excel, macro e, macro + excel, i want to do excel, heat, heat map, g+12, Excel Formatting, Day Light, heat map excel, excel cell, stock spreadsheet excel, excel color cell, stock excel, macro cell value, macro changes cell, conditions excel, stock excel spreadsheet, stock macro, excel macro simple, stock value excel, simple stock excel, background easy basic, basic formatting

About the Employer:
( 0 reviews ) United States

Project ID: #1282358

50 freelancers are bidding on average $42 for this job

TrustProgrammer

Please let's start task.

$30 USD in 0 days
(0 Reviews)
0.0
Alishanuj

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

$30 USD in 1 day
(0 Reviews)
0.0
mars8246

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.

$30 USD in 0 days
(2 Reviews)
0.0
yasmaester

I'm a product specialist for a certain company, and my main job is checking the inventory count and stock values of items using excel sheet. I have a wide knowledge base with this type of work. I can do in general wha More

$30 USD in 1 day
(1 Review)
0.0
sayli2

Very easy task for me. Expert in in excel. Already did excel project.

$30 USD in 1 day
(29 Reviews)
0.0
morzol

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

$30 USD in 1 day
(0 Reviews)
0.0
srinichal

I will deliver a macro for the same

$40 USD in 2 days
(50 Reviews)
0.0
shivkumar29

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

$50 USD in 2 days
(0 Reviews)
0.0
dineshkothari

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.

$30 USD in 2 days
(1 Review)
0.0
imudita

I could do it. Please see PM.

$30 USD in 1 day
(31 Reviews)
0.0
michaelcorleone

i have good experience with excel macro..i will carry out at the earliest..

$30 USD in 0 days
(0 Reviews)
0.0
integerboy

i can finish this less than 20 minutes,, contact me,,

$30 USD in 0 days
(0 Reviews)
0.0
vbexcel

Excel / VBA expert - ten years experience.

$40 USD in 1 day
(34 Reviews)
0.0
xl9ja

I will handle this assignment with speed and dispatch.

$70 USD in 5 days
(0 Reviews)
0.0
AliveSoftwares

Alive Softwares Pvt. Ltd is a software development company based in the India. We provide operational development framework to our clients with the security. We identify the companies' needs and work with our developme More

$30 USD in 1 day
(0 Reviews)
0.0
hasitha1986

i like 2 do this

$30 USD in 2 days
(0 Reviews)
0.0
bharath0424

I would love to work on this project. Excel is my forte.

$30 USD in 0 days
(0 Reviews)
0.0
dsenthilbe

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

$30 USD in 0 days
(0 Reviews)
0.0
baberwaseem1

Hello Sir, I am an Excel expert and confident to develop your solution using conditional formatting within 2 days.

$30 USD in 2 days
(0 Reviews)
0.0
Krusche

Our solution offering: 1) As many condition formattings as you need. 2) User friendly interfaced form - as the innate Excel's one (called by a keys combination) to manage the formatting rules and colors; can be also ad More

$90 USD in 0 days
(30 Reviews)
0.0