Hi snb,

We originally had this set as a conditional format, however we couldn't work out a function to count each conditionally-coloured cell per row.

We have approx 80 columns and 2000 rows of data so nesting countif and vlookups for this many cells isn't something we want to consider at this stage.

Are you aware of any basic functions that could be used instead of vba to counter this?