No VBA necessary, the simplest solution would be to populate the fourt
column with this:

=COUNTIF(E10:G10,"5")

We're not counting red cells, but we are using the same criteria a
your conditional format

--
Message posted from http://www.ExcelForum.com