

August 25, 2017

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

VIP

Trusted Members

June 25, 2016

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

VIP

Trusted Members

June 25, 2016

1 Guest(s)
