Microsoft Office Forums - View Single Post - Total cells based on text color

Thread: Total cells based on text color

View Single Post

Old

10-04-2018, 03:31 PM

PomDave

PomDave is offline

PomDave uses Windows Vista

Windows Vista PomDave uses Office 2010 32bit

PomDave uses Office 2010 32bit

Office 2010 32bit

Advanced Beginner

The original poster

Join Date: Sep 2011

Location: Australia

Posts: 43

PomDave is on a distinguished road

Default

Total cells based on text color

Hi All,

Is it possible to total a range of cell values based on the text color i.e.

6 cells 2 are in Green and 4 are in Red.

I want to get the value of each set.

Best Rgds
Dave R.

Reply With Quote