View Single Post
  #1   Report Post  
themax16
 
Posts: n/a
Default Formula to count Cell colour.


Morning all,
I am looking to set up a formula to count cells IF they are a filled
with a specific colour. Is this possible as i cannot find any way to
ask to countif - eg green.
I have tried everything i could think of - =COUNTIF(C5:BI24,(GREEN))
Any help will be greatly appreciated.
James


--
themax16
------------------------------------------------------------------------
themax16's Profile: http://www.excelforum.com/member.php...o&userid=23622
View this thread: http://www.excelforum.com/showthread...hreadid=374893