Conditional formatting & data validation

Hi EXCELsior44,

We will need to see this in action. You will need to attach an Excel workbook (with data desensitized) that demonstrates what you are describing.

If you are not familiar with how to do this:

• To attach a file to your post,
• click “Go Advanced” (next to Post Quick Reply – bottom right),
• scroll down until you see “Manage Attachments”, click that,
• click “Browse”.
• select your file(s)
• click “Upload”
• click “Close window”
• click “Submit Reply”
• The file name will appear at the bottom of your reply.