Flag or Conditional Formatting?

Morgan E Kelly

I want a way to 'flag' a cell if it is out of range of two other cell dates. I haven't been able how to do that with conditional formatting because I can't set a condition to say if "this column" is NOT between "this column" and "this column" (where the dates change for each row). Is there a way to do that?

I thought I had figured out a work around by using the flag function but I can't seem to get the formula to work. This is what I'm using:

What am I doing wrong? Any suggestions to either use conditional formatting or the flag function (by correcting the formula)?

Kelly Moore

Hey @Morgan E Kelly

Try this

=IF(OR([Date Planned ED-P]@row <= [Earliest Date]@row, [Latest Date]@row <= [Date Planned ED-P]@row), 1, 0)

cheers

Kelly Moore

Hey @Morgan E Kelly

Try this

=IF(OR([Date Planned ED-P]@row <= [Earliest Date]@row, [Latest Date]@row <= [Date Planned ED-P]@row), 1, 0)

cheers

Morgan E Kelly

I had to take out the "=" but the OR worked! Thanks so much!