Conditional Formatting

[luciedefreitas]

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

[luciedefreitas]

I've attached the spreadsheet Thanks

[gmsninja]

Hi luciedefreitas
I have added the conditional formatting to column R (just for the range of data you currently have populated
To explain, under conditional formatting choose 'highlight cell rules' then from the list 'More rules'
Choose use a formula to determine which cells to format
this is the formula based on
"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."
formula: =AND($M4>0,$O4=1,$R4>10)
applies to: Complaints!$R$4:$R$15

If you change cell R4 to 11 you will see it formats
Let me know how you go!NHHO Complaints test.xlsx

[FDibbins]

1. highlight the range you want to apply the conditional formatting to
2. on the home tab, styles, select CF
3. select new rule, select use formula
4. enter =OR(AND(N4<>"",O4=1,R4>10),AND(N4<>"",O4=2,R4>15))

None of your sample data matches those criteria though, so test it on additional data

[gmsninja]

Hi FDibbins

This thread was a question from luciedefreitas, I offered a solution

[FDibbins]

gmsninja, my most sincere apologies I used the wrong canned reply to you (I have deleted it), it should have read...

I notice that the file you uploaded indicates 2007 or later (.xlsx), but your profile says 2003. Please update your profile as necessary, members tailor questions based on your excel version