Excel Conditional Format Question (basic!)

[sandy10]

Hi guys,

Looking for literally 2 mins help with a very small part of an excel spreadsheet - I'm a real novice and I'm sure someone with grey matter will solve in a moment.

Can anyone spare me a second or two please?

 

[sandy10]

I've just written a conditional format on a spreadsheet which is basically a stock level inventory, and when the stock of an item falls below 100 for instance, the row turns red

Is there a way to copy the condition to other rows I've previously populated with text and numbers?

 

[sandy10]

Larty - I've just tried and it worked - awesome, thank you

 

[sandy10]

Thank you guys