If you can write the formula, you can use conditional formatting (I know, not helpful.)

Select the first column's cell in a dummy row. Select Conditional Formatting, Highlight Cell Rules, More Rules, then select Use a formula to determine which cells to format. Type the formula, then select the format with the Format... button. Pick red highlighting.

Do the same for the second column's cell, then the third.

Then you can select all three cells and do Copy, then Paste Special... Formats to the real data.

Probably not clear, but I tested it with a very simple formula, =IF($C1=$A1, true). If you can write the formula, you can get the highlighting to work.

Le bump

So I want to color a row, up until a particular cell in the event that a cell is blank within 2 day before an event

So A1 has a date. A2 a description. A3 has an empty cell

If today is 3 days or sooner of the date in A1, and A3 is blank, then I want cells A1, A2, and A3 to be shaded red.

How do I do this?