Forum Discussion

Luladrao's avatar
Luladrao
Copper Contributor
Oct 26, 2024

How to Conditional Formatting This?

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.

2 Replies

  • Luladrao 

    Let's say that the Date column is column B.

    Change the formula for the conditional formatting rule to

     

    =AND($D3=$H$2, $B3>=$I$1, $B3<=$N$1)

    • Luladrao's avatar
      Luladrao
      Copper Contributor
      I would like to thank Hans for the prompt answer which completely resolved my issue. I really appreciate it.

Resources