Finding cells incorrectly completed

[PhilH1982]

On a sheet I have created, I have set up some formulas that count if any rows have been incorrectly completed.

It also counts the total number of rows and how many rows have missing data which we need.

Is there any way of actually listing which row the error appears on rather than knowing I maybe have 3 errors and having to scroll through the entire worksheet?


Counts are as follows

If column H has a "Y" then so should column I.

If column G has a "C" or "M" then a date must be entered into column J or K.

Columns B, E and F must always be completed.

[jovialtom]

try using some conditional formatting which will highlight where the errors appear.
Tom