Conditional formatting if a range of cells contain 1

[Dibbley247]

Hi

How would I go about conditional formatting range P1 to be GREEN if A1 B1 C1 and N4 = 1 else it would display RED

it has been a while since i've used a formula for conditional formatting

Many Thanks

[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(A1=1,B1=1,C1=1,N4=1) format GREEN

For the RED...
3. select new rule, select use formula
4. enter =AND(A1<>1,B1<>1,C1<>1,N4<>1) format RED

[Dibbley247]

Ah I would never have thought to put the OR and AND in there!!!
Thanks a bunch, I will try this tomorrow, I need my bed!!!!

Thanks again.

[FDibbins]

Happy to help, let me know how you make out

[martindwilson]

you could probably just colour red fill rather than use
=AND(A1<>1,B1<>1,C1<>1,N4<>1) condition

[FDibbins]

yes, depending on what else they want, that might be a better option, Martin

[martindwilson]

then again it might be quicker to use the cf

[FDibbins]

Do I detect another IF() inthere, Martin?