Hi Keith,

Am Fri, 20 Mar 2020 04:31:11 -0700 (PDT) schrieb Keith Tizzard:

I have two columns of dates, let's say columns H and J

I wish to highlight cells in Column J that are at least 4 weeks later than corresponding cells (ie same row) in column H.

I select column J and create a conditional formatting:
'Use formula to determine which cells to format'
and for 'Format values where this formula is true, I enter:
=">$H:$H+28"

select column J and use

=H1+28

Regards
Claus B.
--
Windows10
Office 2016

--- SoupGate-Win32 v1.05
* Origin: fsxNet Usenet Gateway (21:1/5)

I have two columns of dates, let's say columns H and J

I wish to highlight cells in Column J that are at least 4 weeks later than corresponding cells (ie same row) in column H.

I select column J and create a conditional formatting:
'Use formula to determine which cells to format'
and for 'Format values where this formula is true, I enter:
=">$H:$H+28"

then set some formatting colour.

Result: no cells are highlighted

When I look at the conditional formats for the Worksheet, it shows:

Formula: ">$H:$H+28"
Applies to: =$J:$J

Looks right but ......

How should I achieve this?

--- SoupGate-Win32 v1.05
* Origin: fsxNet Usenet Gateway (21:1/5)