Row Color Change - Based upon formula content

cpo1wh

I would like to color an entire row, based upon the result from a date formula. Is that possible? For example, if today's date field is x number of days beyond another date field, I would like to color the entire row a specific color. Thanks for your help.

David Joyeuse

Condition formatting does not allow you to using conditions between two or more cells.

So I would suggest the use of an helper column, preferably a checkbox type. If Date A is x number of days beyond Date B, then check the box.

=IF(DATE-A@row>(DATE-B@row+X),1,0)

Then use conditional formatting based on the checkbox. It'll do the trick.