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?
 

Some videos you may like

Excel Facts

What is the fastest way to copy a formula?
If A2:A50000 contain data. Enter a formula in B2. Select B2. Double-click the Fill Handle and Excel will shoot the formula down to B50000.

Brian from Maui

MrExcel MVP
Joined
Feb 16, 2002
Messages
8,458
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
 

Watch MrExcel Video

Forum statistics

Threads
1,122,809
Messages
5,598,202
Members
414,218
Latest member
speedbit

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