sum if with a color change

[sirwolf2017]

I am very new at this .

I have created this formula =SUMIF(info!B:B,apache!A2,info!C:C) which works great now I would like to have it go a step further. I need it to also change the color of the the cell "info!B:B" if it equals the cell "apache!A2" any help would be greatly appreciated

[greenfox74]

Have you tried conditional formatting? Or are you looking for something more complex? Conditional formatting I would think would be easiest and fastest.

[FDibbins]

Have you tried conditional formatting? Or are you looking for something more complex? Conditional formatting I would think would be easiest and fastest.

Other than VBA, Conditional Formatting is the only way to do this

sirwolf2017 welcome to the forum

I am a liitle confused by this comment...

cell "info!B:B"

info!B:B is a range, not a cell?

Anyway, as indicated, you would need to do this with Conditional Formatting...
1. highlight the range you want to apply the conditional formatting to
2. on the home tab, styles, select CF
3. select new rule, select use formula
4. enter =B1=apache!a2...Format Fill your color choice