Change Cell Colour Based On Range of Cells

[David102938]

So I have a range of cells for a worksheet (C5:Q5 to be precise) and I want cell BY to turn red if all of those cells are blank, I know I can use Conditional Formatting to do this but I'm not sure what formula to use. Would I be able to do it for one row and then quickly do it for other rows? Or would I need to redo the process for each row, and would I be able to add in extra columns between C5 and Q5 and keep the rule?

Any help is much appreciated!

 

[David102938]

Actually, one more thing, how can I quickly apply this to other cells (But obviously using row 5, then 6 and so on, without having to re-type the whole thing, I saw someone mentioned using the Format Painter, but I'm not sure how I'd go about that

 

[James006]

Glad you could fix your problem ...

 

[Fluff]

Actually, one more thing, how can I quickly apply this to other cells (But obviously using row 5, then 6 and so on, without having to re-type the whole thing, I saw someone mentioned using the Format Painter, but I'm not sure how I'd go about that

Simply select the cells you want the formula to work on (eg B5:B15), then create a rule & enter the formula.