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

51 freelancers are bidding on average $41 for this job

svet63

VBA developer since 1997. Can do. Regards, Svet.

$50 USD in 0 days
(78 Reviews)
6.7
koolsidz

Excel Whiz here ;) This is an hour's job for me. Please see PMB for more details.

$35 USD in 0 days
(116 Reviews)
5.8
srinichal

I will deliver a macro for the same

$40 USD in 2 days
(32 Reviews)
5.7
nagybatonyi

I can provide for you either an Excel2003 macro or an Excel2007/2010 series of conditional formatting rules according to your needs.

$40 USD in 1 day
(47 Reviews)
5.6
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
(29 Reviews)
5.6
vbexcel

Excel / VBA expert - ten years experience.

$40 USD in 1 day
(26 Reviews)
5.4
binaryromel

##### Excel expert here! Please check PM. #####

$35 USD in 0 days
(47 Reviews)
5.2
rajanlengde

PLease see PMB

$30 USD in 0 days
(27 Reviews)
5.1
best4best

Please refer PMB.

$30 USD in 1 day
(58 Reviews)
5.0
simplicityq88

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).

$30 USD in 2 days
(43 Reviews)
4.8
imudita

I could do it. Please see PM.

$30 USD in 1 day
(29 Reviews)
4.8
chriskerpini

A similar macro (with about 15 conditions) is already written and tested throughly. I will adjust it to your specifications when I have them. A few words about me: Very experienced in both Excel and VBA, teaching the More

$30 USD in 0 days
(12 Reviews)
4.4
carmenli

Hello. I can provide a high-quality solution very quickly. Please check PM for further details. Thank you.

$30 USD in 1 day
(20 Reviews)
4.3
microk

Excel whiz here... See sample in PM...

$30 USD in 1 day
(20 Reviews)
4.3
Gooroo

Seek no more! I can do it either way and very fast. Kindly see attachment in PM. Thanks!

$38 USD in 1 day
(15 Reviews)
4.2
piyushdpatel

Hi This is Piyush Patel I have 6 yrs of Exp in VBA,VB6,VB.net,SQL and MsAccess. I have developed many applications in VB6,VB.NET. Please Check My PM

$50 USD in 1 day
(11 Reviews)
4.0
vgrichards

Very Good at Excel 2003-2010 and Excel VBA Macros. Please allow me to do it. Will ensure everything is as per your requirement.

$30 USD in 1 day
(24 Reviews)
4.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)
4.0
Barns

Sample excel spreadsheet with running macro and details provided in PMB. We have a 100% project completion rate.

$30 USD in 1 day
(9 Reviews)
3.8
sayli2

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

$30 USD in 1 day
(19 Reviews)
3.1