Forum Discussion
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 car...
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)
I would like to thank Hans for the prompt answer which completely resolved my issue. I really appreciate it.