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
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