Conditional Formatting - copy across multiple rows/columns

[katel99]

Hi there,

I am trying to apply conditional formatting across a worksheet, based on this formula;

=BC3<bc14">< BC14</bc14">

HOWEVER

I have read multiple forums/blogs/posts about this and I can't seem to get the conditioning to apply across further rows/columns. I am not using absolute references, and when I have tried applying the formula to a range all the cells (apart from BC3) are remaining white...

So for example, I need the rule to update to =BC4<bc15 on...=""> < BC15 or =BD3 < BD14

What am I missing??

Thanks in advance,

Kate</bc15>

 

[steve the fish]

Highlight your cells you want to format with the topmost left hand side cell of the range being BC3. Then apply the formula and choose your formatting.

 

[katel99]

Amazing, thank you It works!