Excel Cell Criteria Effect
 

Dear Helper,

First of all , thanks for your attention. I have one question.

Using VB, I need to check the background color of one cell in the Excel,
e.g. A1.
How can I know in the command, e.g. range("A1").????

Moreover, if this cell has formating or some criteria, e.g. if the value is
larger than one
number, then show it in yellow.
Would this effect or cannot give the value???

As We find that the cell show red font but .range("A1").font.color show "0".

That is why I asked such a question.


Thanks for your attention.

Raymond Chiu

Excel Cell Criteria Effect
 

See response in worksheet.functions


--

HTH

RP
(remove nothere from the email address if mailing direct)


"raymond chiu" wrote in message
...
Dear Helper,

First of all , thanks for your attention. I have one question.

Using VB, I need to check the background color of one cell in the Excel,
e.g. A1.
How can I know in the command, e.g. range("A1").????

Moreover, if this cell has formating or some criteria, e.g. if the value
is
larger than one
number, then show it in yellow.
Would this effect or cannot give the value???

As We find that the cell show red font but .range("A1").font.color show
"0".

That is why I asked such a question.


Thanks for your attention.

Raymond Chiu