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
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
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
Sunny
As always, "you rock"!
Thanks
Hi Melinda
Thanks for your compliments.
Sunny