I have a running sheet for my expenses.
I would like to setup conditional formatting/Macro/ect. that looks in cells of THE CURRENT MONTH, then any cell that has the text "paid" FOR THE CURRENT MONTH it will apply a gray fill for THE ROW that the cell is in.
SOLVED, thanks to help from @Marc K I ended up with the following formula that I created conditional formatting for each month of the first expense in my list.
Best How To :
Assuming a table like this
| Pd Date | Status | |----------|---------| | 4/1/2015 | paid | | 5/7/2015 | denied | | 5/11/2015| paid | | 5/11/2015| pending |
You should be able to set conditional formatting using a formula to the row with
Adding a year criteria to filter further.
The is number function is checking to make sure that "paid" is found in the cell. The remainder is doing combined date comparisons.