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

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

this kind of worked but in the wrong way. by using as my only formulae and
setting the format for if the est date isnt filled in it marks everything in
red if under 5 and est filled in which is the reverse of how i need it to
work. in addition our customer has requested a slight change in
functionality. here is how it now must work.

data starts on row 8 elapsed is in column I and estimate date is in column J
elapsed time from accident date to estimate date is in hidden column K. the
conditions for formating are as follows:

if k9 is greater than 4 and estimate date field is empty then cell in I9 is
to be formatting with red shadin and bold white text..

if value in k9 is 4 or less or J9 is NOT empty then I9 is to be formatted
with shading set to AUTO text colour set to AUTO and no border.

how can this be done?

--
Stuart


"Bob Umlas, Excel MVP" wrote:

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