I have a spreadsheet containing columns “Date, Amount Paid, and Credit Card Used”. Every month I have to check this spreadsheet with statements for each credit card. To do this I enter the credit card number in cell H2, the start date in cell I1 and last date of the statement in cell N1. When I enter those values I have a Conditional Formatting filling with yellow color all rows containing that credit card number in all dates. The problem I have is that all rows for that card become yellow in the whole spreadsheet. How can I have yellow rows only for the dates in the range I specified. My spreadsheet Conditional Formatting looks like this: =$D3=$H$2. Column D for credit card numbers and cell H2 is where I enter the credit card number. I will appreciate any suggestions.

​I have a spreadsheet containing columns “Date, Amount Paid, and Credit Card Used”. Every month I have to check this spreadsheet with statements for each credit card. To do this I enter the credit card number in cell H2, the start date in cell I1 and last date of the statement in cell N1. When I enter those values I have a Conditional Formatting filling with yellow color all rows containing that credit card number in all dates. The problem I have is that all rows for that card become yellow in the whole spreadsheet. How can I have yellow rows only for the dates in the range I specified. My spreadsheet Conditional Formatting looks like this: =$D3=$H$2. Column D for credit card numbers and cell H2 is where I enter the credit card number. I will appreciate any suggestions.  Read More

​