Conditional formatting question

Assuming your first column is A and second column is B. And the data can be there in the range A2:A100, then select the range A2:A100 and make New Rule for conditional formatting using the formulas given below...

For Green

Please Login or Register  to view this content.

For Red

Please Login or Register  to view this content.

Change the column and range reference as per your need.
Hope this helps.

Hi Sktneer,

Thank you for the reply. I may be doing something incorrectly because it's not working the way it should. Just to simplify the example in column A I put in some sample data, numbers 1 through 10 through cell A10. In column B I applied the formulas you kindly provided and then entered some data to see if it would respond correctly. Here are the issues I found:

For some reason if the value doesn't exist, in this case I chose the number 11, it did not make the cell red.
If the numbers did match it would highlight the cell next to the value in column A with red instead of highlighting the cell in column B with green.
If the value happened to match and be in the same row the cells would turn white.

Maybe I did a poor job of explaining what I need? Column A will be populated with data, column B's job is to search column A for the data and if it matches, no matter what row it's in, turn it green, if it doesn't, turn it red.

To apply the conditional formatting I simply went to new rules and used the "use a forumla to determine which cells to format" section, is that correct? Thank you again for the help!

As per your example, Assuming range A1:A10 has numbers from 1 to 10. Now select B1:B10 and make new rule using the below formulas

For green

Please Login or Register  to view this content.

For red

Please Login or Register  to view this content.

Find the attached sheet to see if this is what you are trying to do and if its not, please upload a sample workbook with desired output.

You're welcome. Thanks for the feedback.
If that takes care of your question, please mark your thread as solved by selecting Thread Tools (just above your first post) --> Mark thread as solved.
Moreover you may also click on * (star) to Add Reputation to those who have put their time and efforts to help you in this forum. This is another way to say thanks to them.