Forum

macro for condition...
 
Notifications
Clear all

macro for conditional format error

5 Posts
2 Users
0 Reactions
85 Views
(@mymalone)
Posts: 103
Estimable Member
Topic starter
 

I received a conditional format error:  not enough system resources to display the dialog". 

So, I am wondering would a macro be better or the work around.

Can you help me create the macro?

 

If columns Y:AD has "M" marked in the cell, then go to Columns C:H and highlight the cell.  Interior Color with Bold lettering.

File attached.

 

Thanks

 
Posted : 27/09/2018 12:56 pm
(@sunnykow)
Posts: 1417
Noble Member
 

Hi Melinda

Your attachment did not contain the CF so no idea if you set it up correctly.

You can refer my attachment to see if it meet your needs.

A macro solution will be tougher as a lot of things must be taken into consideration:

1) Number of rows of data

2) Number of columns

3) Position of the data (starting column/row) etc

Since most macros are hard-coded the placement of the data is very important.

If you can show us the actual file (with dummy data of course) it will help make us understand the situation better.

Sunny

 
Posted : 27/09/2018 8:51 pm
(@sunnykow)
Posts: 1417
Noble Member
 

Here is the macro version.

Please note that I have hard-coded the ranges. You will need to change it if it is different.

Hope this helps

Sunny

 
Posted : 27/09/2018 9:59 pm
(@mymalone)
Posts: 103
Estimable Member
Topic starter
 

Sunny

As always, "you rock"! 

Thanks

 
Posted : 06/10/2018 12:08 pm
(@sunnykow)
Posts: 1417
Noble Member
 

Hi Melinda

Thanks for your compliments. Laugh

Sunny

 
Posted : 06/10/2018 7:29 pm
Share: