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

arunsjain

Board Regular
Joined
Apr 29, 2016
Messages
92
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
 

Some videos you may like

Excel Facts

What is the shortcut key for Format Selection?
Ctrl+1 (the number one) will open the Format dialog for whatever is selected.

Johnny C

Well-known Member
Joined
Nov 7, 2006
Messages
1,003
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

Board Regular
Joined
Apr 29, 2016
Messages
92
Thank you Johnny, such a simple solution.
Great!!!
 
Last edited:

Watch MrExcel Video

Forum statistics

Threads
1,122,657
Messages
5,597,391
Members
414,142
Latest member
Banyangt

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top