can you could cells which have been conditionally formatted?
I've coloured the background in red so basically I want to count how many red cells are on that row.
I've used a formular for formatting which is = =ISNUMBER(SEARCH("/06",A1:ZZ200))
Thanks.
Bookmarks