Hi All,

I would like to be able to conditionally format an entire column of data, row by row, depending on 2 sets of criteria.

In column R I have no of days - this is the column I would like to conditionally format to red and bold font if it meets the following criteria:

- If corresponding cell in same row of column N s not blank and cell in same row of column O is 1, and R is more than 10, format.

OR

- If corresponding cell in same row of column N s not blank and cell in same row of column O is 2, and R is more than 15, format.

Can someone please tell me how to do this?

I've been trying all week but all i manage to do it make the whole column red regardless of any formula.


Thanks
NHHO Complaints test.xlsx