Thread: conditional formatting

I am trying to copy down the formatting for R4,L4,N4,P4
I am having trouble keeping the rows separate. when I copy down TO 500 it wants to reference row four for all rows?
any help?
THANKS

Hi,

your question is a bit confusing, do you want to apply the conditional formatting of L4,N4,P4,R4 to other rows....? if so you can set the range in conditional formatting "Applies to" field only.... chk the attached file if it solves.

And the formula from O5 has #REF. chk once

Originally Posted by mojobaabby

I am trying to copy down the formatting for R4,L4,N4,P4
I am having trouble keeping the rows separate. when I copy down TO 500 it wants to reference row four for all rows?
any help?
THANKS

thanks but you have the same issue I am having. Keeps referencing the info in M4 all the way down?

can u explain a bit clear what xcatly u what....?

explain clear what you r trying to do,

What does "Keeps referencing the info in M4 all the way down?" this mean....?

Originally Posted by mojobaabby

thanks but you have the same issue I am having. Keeps referencing the info in M4 all the way down?

if conditions are true for M4 why when blank does M5:M?? go red? I need conditions in each row to be for that row only