# formulate a format?

#### ultratch47

##### Board Regular
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
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
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

#### Iridium

##### Well-known Member

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.

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.

### Which adblocker are you using?

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

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