Conditional Formatting vb code
 

I used code that was to format a range of cells when the cell was clicked. I
have several ranges that need to be formatted in that way. I have named the
ranges "Shading". How can I amend the code to check that cell range?

Conditional Formatting vb code
 

hi
it might help if you posted your code.

Regards
FSt1

"beverlydawn" wrote:

I used code that was to format a range of cells when the cell was clicked. I
have several ranges that need to be formatted in that way. I have named the
ranges "Shading". How can I amend the code to check that cell range?