formulate a format?

ultratch47

Board Regular
Joined
Aug 6, 2002
Messages
126
is this possible?

A1 = blue fill
A2 = yellow fill
then the sum (@ A3) will be another selected color (green)

if three different color... (sum = black?)

thanks
the fill of cell A1 and A2 is the result of a conditional format

i suppose one possible solution would be to also place a number in the cell.
then if the sum of numbers = a number, then conditional format

would this work and is this the only way?
 

Excel Facts

How can you turn a range sideways?
Copy the range. Select a blank cell. Right-click, Paste Special, then choose Transpose.

Brian from Maui

MrExcel MVP
Joined
Feb 16, 2002
Messages
8,459
ultratch47 said:
is this possible?

A1 = blue fill
A2 = yellow fill
then the sum (@ A3) will be another selected color (green)

if three different color... (sum = black?)

thanks
the fill of cell A1 and A2 is the result of a conditional format

i suppose one possible solution would be to also place a number in the cell.
then if the sum of numbers = a number, then conditional format

would this work and is this the only way?

What's the conditional format in A1 and A2?
 

ultratch47

Board Regular
Joined
Aug 6, 2002
Messages
126
A1 =.........=AND(N$1>=$B$2,N$1<=$C$2)
A2 =.........=And(N$1>=$C$2,N$1<=$C$2)

i am using a Gnatt chart...
basically, i want to take about 80 lines of data, many of them blank...
and turn them into one line, (if only one thing was done between a time, then the color will remain the same, if 2 jobs, i can have a color for when the 2 thing colors are combined, and if more than 2, then give black color)

make sense?

thanks
 
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,168,091
Messages
5,857,310
Members
431,870
Latest member
Muratculous

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