Posted to microsoft.public.excel.worksheet.functions

TJ[_2_]

external usenet poster

Posts: 12

Counting based on format

Hi

Is there a worksheet function, or combination of functions, that I can use
to count how may cells in a row have a background of red? E.g
=Countif(A2:A10, "Background = Red").

Thanks
TJ

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
counting Ps and Ls based on the date in another row.	Gary	Excel Worksheet Functions	2	February 8th 07 06:58 PM
Counting based upon 2 conditions that are text based	walkerdayle	Excel Discussion (Misc queries)	7	August 22nd 06 01:29 AM
Counting cells based on formatting	JRJ	Excel Worksheet Functions	2	June 5th 06 11:26 PM
counting based on criteria	SOT	Excel Worksheet Functions	0	March 9th 05 05:25 PM
counting based on 2 conditions	Thrava	Excel Discussion (Misc queries)	3	December 8th 04 10:19 PM

All times are GMT +1. The time now is 03:12 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us