Conditional formatting query

[perrina]

I'm struggling with something, hope someone cal help me!

I have a worksheet whereby I want cells A-F to fill red, orange or green dependent on the range of a number contained in Cell G. I get this all set up and it works but its only filling cell A with colour. Can it be done where it fills all 6 cells across the row?

Thank you!
Kevin

[Tony Valko]

Can it be done where it fills all 6 cells across the row?

Yes.

Tell us what the rules are for the cells to be colored:

Cells are red when?

Cells are orange when?

Cells are green when?

[perrina]

Hi thanks for the reply.

In more detail, I want cells A-F to be the following fill colours when the number in cell G is set to:

0 = No fill
1-25 = Green
26-30 = Orange
31 and above = Red

Thanks,

Kevin

[popipipo]

Take a look at this sample using CF

[perrina]

You star!!

I see you specify cells A-F in the 'applies to' box... Thank you thank you!