Dear all,
I would like the background of cells I13 to I29 to change if:
1) they are empty AND
2) the 1st digit of their corresponding cell in column A is less than 3.
Could someone please give me a code for this. I have tried to use conditional formatting but I cannot get both conditions together.
Could someone help please.
PS. I do not mind what colour the cell becomes as I guess it will be defined by a number which I can change if necessary.
Thank you in advance for your help.
Regards,
Cdmg
Bookmarks