Combine conditional format formula into one.

[hro5e]

Hi there,

I have 5 conditional formats that I need to combine into one.

Conditional format 1 =AND(M$9>=$J19,M$9<$J19+ROUNDDOWN($D19*($K19-$J19+1),0))
Conditional format 2 =AND(M$10>=$J19,M$10<$J19+ROUNDDOWN($D19*($K19-$J19+1),0))
Conditional format 3 =AND(M$11>=$J19,M$11<$J19+ROUNDDOWN($D19*($K19-$J19+1),0))
Conditional format 4 =AND(M$12>=$J19,M$12<$J19+ROUNDDOWN($D19*($K19-$J19+1),0))
Conditional format 5 =AND(M$13>=$J19,M$13<$J19+ROUNDDOWN($D19*($K19-$J19+1),0))

They are carry the same formatting hence why I would like them to be combined into one as apposed to five.

Any help would be greatly appreciated.

 

[Joe4]

You can use OR to combine those five formulas into one rule, i.e.

=OR(formula1,formula2,formula3,formula4,formula5)

 

[hro5e]

You can use OR to combine those five formulas into one rule, i.e.

=OR(formula1,formula2,formula3,formula4,formula5)

Magic, sorted it first time. I was overcomplicating it. Thank you.

 

[Joe4]

You are welcome.
Glad I was able to help!