View Single Post
  #1  
Old July 23rd, 2004, 01:40 PM
external usenet poster
 
Posts: n/a
Default counting cells in a range having certain format

Is there a way to use the countif function to count cells
in a range with 1) a red background and 2) that contain
letter "A". Something like the following.

=COUNTIF($E112:$K163,Font.Color($P$150))

Thanks in advance, lh