Steve

You said you want this on 11 columns below. I assume you meant 11 rows below.

I also assume you want the cell to be green if it contains Span and it is blue if it contains Cat. To do this, you don't need a countif formula - you can set it to "format only cells that contain" where the cell value is equal to Cat or Span.

__________________
Andrew Lockton
Chrysalis Design, Melbourne Australia