hello all, thanks for your help on the last one. I have a new one now. How would i write the following for a conditional Format
if cell value is equal to any of the values in cells a1,a2,a3,a4,a5,d1,d4,d5
Then the format will be applied to the matching cells
Thanks
if cell value is equal to any of the values in cells a1,a2,a3,a4,a5,d1,d4,d5
Then the format will be applied to the matching cells
Thanks