Select column I. if the active cell is I1, enter this formula in "formula is":
=and(J1<"",I14)

"Stuart" wrote:

i have a report i want to use some conditional formatting on the report, if
the value in the elapsed column "I" has a value that is greater than 4 i need
the background colour to be red and have white text, nnow that part i know
how to do, where it gets complicated is i also need it that if the value in
column "J" (Estimate Date) has a value that is greater than (Empty) then the
red background and white text formatting is to be enullified. how can i do
this?
--
Stuart