# Averaging only font color black and ignoring font color red

#### Ria323

##### New Member
*Looking to carry down the formula to many cells after it in the average column

The formula below is what I have so far. I need to EXCLUDE the red font from the calculations. With my current formula, it is still including it since it's =*red*, I've tried <>*red but when I pull the formula down to the next row where all numbers in Columns N, T and Y are black, it is still excluding Y in the average.

Help?

 Column N Column T Column Y Average \$14.23 \$14.80 \$17.10

=IF(OR(N7="",N7="*red*"),AVERAGE(Y7,T7),IF(OR(T7="",T7="*red*"),AVERAGE(N7,Y7),IF(OR(Y7="",Y7="*red*"),AVERAGE(N7,T7),AVERAGE(N7,T7,Y7))))

### Excel Facts

Does the VLOOKUP table have to be sorted?
No! when you are using an exact match, the VLOOKUP table can be in any order. Best-selling items at the top is actually the best.

#### Fluff

##### MrExcel MVP, Moderator
Formulae cannot "see" formats. Are the red numbers actually negative numbers formatted to show in red?

#### Tom.Jones

##### Active Member
You can't do this with formula.
N7="*red*" cannot be used for font color.
With VBA is possible.

#### Ria323

##### New Member
Formulae cannot "see" formats. Are the red numbers actually negative numbers formatted to show in red?
Ohhh ok. No, they are not negative numbers. Thank you!

#### Ria323

##### New Member
You can't do this with formula.
N7="*red*" cannot be used for font color.
With VBA is possible.
Gotcha, thank you or your help with this!

#### Fluff

##### MrExcel MVP, Moderator
How is the font colour changed?

Replies
26
Views
594
Replies
10
Views
291
Replies
1
Views
370
Replies
10
Views
484
Replies
2
Views
304

1,128,177
Messages
5,629,182
Members
416,370
Latest member
Lgathana

### 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?

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