Hi
Hoping that you can help!
I've applied a VBA code that I got off the internet to help me count conditionally formatted coloured cells.
I only want to count "red" cells by individual row.
The VBA / Formula I am using is returning "NOCOLOR".
Could someone possibly explain where I am going wrong. Sample file can be accessed here Final Reference Tracker sample.xlsm
Thank you in advance
JMAW
Hoping that you can help!
I've applied a VBA code that I got off the internet to help me count conditionally formatted coloured cells.
I only want to count "red" cells by individual row.
The VBA / Formula I am using is returning "NOCOLOR".
Could someone possibly explain where I am going wrong. Sample file can be accessed here Final Reference Tracker sample.xlsm
Thank you in advance

JMAW