Conditional Formatting

blooneptune

Board Regular
Joined
Nov 21, 2005
Messages
79
Hello All.

I run a 3 month course, with a 1 month, 6 month and 12 month follow up. I wish to produce a Gantt chart using conditional formatting. Unfortunately, I am able to show the course duration (say Jan, Feb and March - yellow), I can also show the 1 month follow-up (ie. April - green), however when it comes to 6 and 12 months, and with the limitation of 3 conditions, I am only able to show the 6 and 12 month as 1 period (all months highlighted between the 6 and 12 month gap). Any ideas on how I am able to display all the required dates, without contemplating more software such as Project.

Thanks for the help.
 

Excel Facts

Square and cube roots
The =SQRT(25) is a square root. For a cube root, use =125^(1/3). For a fourth root, use =625^(1/4).

nbrcrunch

Well-known Member
Joined
Jan 1, 2003
Messages
2,062
Wait a few months until Excel version 12 is released with unlimited conditonal formatting. :)

MrExcel has programmers for hire that can write VBA code (if you are unable) that can handle your needs.
 

Belgarth58

New Member
Joined
Feb 7, 2006
Messages
24
I was looking for this answer as well, and its helped me so much.... however how do you make the first letter uppercase ? and not lower.

Cheers
 

StevenW-UK

New Member
Joined
Mar 24, 2005
Messages
5
This looks like just what I need to solve a problem I am having with more than 3 conditions needed.

However, I need to set a border on a cell when a condition is met (just outline the cell with standard border). How would this be coded in the VBA?

Cheers
 
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

Forum statistics

Threads
1,164,019
Messages
5,834,980
Members
430,331
Latest member
Syed Yasir Hannan

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top