Error message based on any cell color in a range where conditional formatting is applied on that range of cells

[arunsjain]

Hi,

I have applied conditional formatting in range of cells like C1:D100. These cells contains formula like if A1>0 then "Fine", otherwise "Error-check again".

If any of the cell in that range contains "Error" word then fill that cell with red color as conditional formatting is applied on that range.

Is there any way that a warning message appear that there is an error in worksheet on running VBA codes?

Please help !!

Kind Regards
Arun

 

[Johnny C]

I'm not sure about the VBA side, I've no idea what it's doing.

However you could put a formula somewhere
=COUNTIFS(C1:D100,"*Error*")
and it will count how many cells have Error somewhere in them. If the value is >0 you have an error.

HTH

 

[arunsjain]

Thank you Johnny, such a simple solution.
Great!!!