Vba code A1 to Z10, selected for the cell to a previous column of black yellow cell values, and in the message box prompts,

Each column is known to be only a cell has a color,

CodePudding user response:

Yellow cell is the cell with black on the same line?

CodePudding user response:

Each column cells there is only one cell of any color

CodePudding user response:

A10 A1 to have data, not empty,

CodePudding user response:

The

1/f, reference & gt; _ & amp; lt; S response:

yellow cell is the cell with black on the same line?

Not necessarily on the same line, each cell area has data, not empty,

CodePudding user response:

This kind of writing code, it is best to upload attachments

CodePudding user response:

Statement should be no problem, is mainly how to implement the code,

CodePudding user response:

If you set the conditional formatting, also want to explain

CodePudding user response:

Mickey Mouse

reference 7 floor yeah response:

if you set a conditional formatting, also to explain

I this problem, there is no set conditional formatting, or still couldn't write the code, the along while,

CodePudding user response:

Mickey Mouse

reference 7 floor yeah response:

if you set a conditional formatting, also to explain

Just start with Vba, only a little experience, but to write the code is always wrong, hope to be able to give some hints