COUNTIF

JRolph · Mar 8th, 2002, 12:44 PM

Thanks again to IML for the help. My question now is, to count the number of highlighted cells in a range with COUNTIF, what would I use for the criteria to indicate the highlighted cells?

Mark W. · Mar 8th, 2002, 12:48 PM

COUNTIF examines cell contents -- not formatting.

For an alternative see my posting at http://www.mrexcel.com/board/viewtop...c=1621&forum=2.

[ This Message was edited by: Mark W. on 2002-03-08 11:58 ]

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Mar 8th, 2002, 12:44 PM	#1
JRolph New Member Join Date: Mar 2002 Posts: 14	Thanks again to IML for the help. My question now is, to count the number of highlighted cells in a range with COUNTIF, what would I use for the criteria to indicate the highlighted cells?

Mar 8th, 2002, 12:48 PM	#2
Mark W. MrExcel MVP Join Date: Feb 2002 Location: Austin, Texas USA Posts: 11,654	COUNTIF examines cell contents -- not formatting. For an alternative see my posting at http://www.mrexcel.com/board/viewtop...c=1621&forum=2. [ This Message was edited by: Mark W. on 2002-03-08 11:58 ]