Hello. I have been working at this for a bit and I can't seem to take any more steps. I feel like it should be really simple.
I finally have this conditional formatting to work the way I want but I need to apply it based on the value of a cell.
Basically I have 2 cells with data validation, one where I choose the month number 1 through 12, and another where I choose a day range "1-15" or "16-31".
The intended result is that the rows for which the conditional formatting rule applies will highlight text in red font when I select the month and day range.
Currently my rule looks like this which works when I select the cell which has my number for the month and 1-15 to highlight those days.
=OR(AND(MONTH($T3)=$Z$13,$Z$14="1-15",DAY($T3)<16),AND(MONTH($T3)=$Z$13,$Z$14="16-31",DAY($T3>15)))
Of course because of the OR, it doesn't work when I select "16-31" for the date range. Multiple tries with an IF condition haven't worked. Help would be very much appreciated.
Bookmarks