Conditional formatting one cell to a column

[Billvh]

I have a workbook with several worksheets in it.

I want to conditional format one column on one work sheet when:

• It matches the same exact number that could be in and any cell in a column in another worksheet
• Example: conditional format if – Review $G$11:$G$107 matches List $C$5:$C$329

Could anybody help me with this?


Thanks,

 

[Billvh]

Thanks again for your help.

This worked well, but I had to use this formula.

=ISNUMBER(MATCH($G3,List!$C$5:$C$329,0))

I wasn’t sure how to apply the same thing I had above in your formula.

=VLOOKUP($G11,ListValues,1,0)<>""


I have a few other questions that maybe you could help me with.

1. Is the VLOOKUP a better option than ISNUMBER?
2. In the above formula the conditional formatting happens when the values in column G match the values in column C5:C329. Then column D has additional information that I would like to be entered into the cell that’s formatted.

• For example: if a number on the G column matches a number in the C column then I want the conditional formatting, but I would also like the value in the D (same row as the C column match) to fill in the cell with the conditional formatting.

1. Last question that I’m sure is very simple, but I can’t seem to pinpoint the problem.

• =ISNUMBER(MATCH($G3,List!$C$5:$C$329,0))
• When using the above formula on the above list it works fine. I’m then using it on another spreadsheet the exact same way, but from different location and here is the issue that I’m having.
  1. It will match the number exactly, but it won’t conditional format
  2. If I enter the same exact number manually it will work and conditionally format
     1. I have tried changing the cell formatting
     2. I have tried format painter from the cell I changed manually, but nothing has seemed to work.

• Do you have any suggestions?

 

[Billvh]

Please forget the last question.

I found that I had a space after the number and that's why I couldn't match.

 

[DanteAmor]

I'm glad you found the problem

 

[Billvh]

I'm glad you found the problem

I misspoke.

I had three questions and I only found the answer to the last one.

If you have the time I would appreciate any help you could give on the first two questions.


Thanks,

 

[DanteAmor]

Thanks again for your help.

This worked well, but I had to use this formula.

=ISNUMBER(MATCH($G3,List!$C$5:$C$329,0))

I wasn’t sure how to apply the same thing I had above in your formula.

=VLOOKUP($G11,ListValues,1,0)<>""


I have a few other questions that maybe you could help me with.

1. Is the VLOOKUP a better option than ISNUMBER?
2. In the above formula the conditional formatting happens when the values in column G match the values in column C5:C329. Then column D has additional information that I would like to be entered into the cell that’s formatted.

• For example: if a number on the G column matches a number in the C column then I want the conditional formatting, but I would also like the value in the D (same row as the C column match) to fill in the cell with the conditional formatting.

1. Is the VLOOKUP a better option than ISNUMBER?

I could comment that the Vlookup only performs one function and the other has 2 functions (isnumber and match)

2. I
In applies to:
=$D$11:$D$15,$S$11:$S$15