conditional formatting dependent on cells not next to eachother...

  • Thread starter Thread starter abulawski
  • Start date Start date
A

abulawski

I want to apply conditional formatting, but I can't figure out th
formula.

I have a row that contains 3 criteria I need in order to color the row
but the 3 criteria are not the same type of cell. (1 cell is a Yes o
No, and the other 2 are dates.)

J3 must be a Y or N
K is text
L is text
M is a date
N is a date
O is a date
P is a date
Q is a date
R is a date

Here is my criteria:
J3 must be Y, N3 or P3 must have an entry, and R3 must have an entry.

If all of these criteria meet, then turn the row the color.

Thank you for any and all help you could provide.

Angel
 
For your example, in J3, use Conditional Formatting, and choose Formula Is
Enter the following: =AND($J3="Y", OR($N3<>"", $P3<>""), $R3<>""
Then, either use the Format Painter, or copy J3 and use Paste Special > Formats, an
apply to your entire table

Hope this helps
Tom McNamar


----- abulawski wrote: -----
I want to apply conditional formatting, but I can't figure out th
formula.
I have a row that contains 3 criteria I need in order to color the row
but the 3 criteria are not the same type of cell. (1 cell is a Yes o
No, and the other 2 are dates.

J3 must be a Y or
K is tex
L is tex
M is a dat
N is a dat
O is a dat
P is a dat
Q is a dat
R is a dat

Here is my criteria
J3 must be Y, N3 or P3 must have an entry, and R3 must have an entry

If all of these criteria meet, then turn the row the color
 
Back
Top