Hi,
Can someone help me with the below code. I want the macro to validate the following two conditions and if both the the conditions are met it should change the cell color format to White.
Conditions are:
1. If Cel.Interior.ColorIndex = 50
2. And If Cel.Value is Not Equal to "(blank)"
Then it should change the Cell Color to White. I have written the following code but its not working. Please help. Thanks.
Please Login or Register to view this content.
Bookmarks