No problem. Glad it does what you want.

--
Ian
--
"Emerogork via OfficeKB.com" <u36894@uwe wrote in message
news:778a853608ac0@uwe...
So cool, thanks. It looks real easy once you have the answer (-:


Ian wrote:
I think I have this right. On rows 8 to 28 you want to compare the values
in
B&D with the values in row 7, every 4th column starting at column G (ie G,
K, O, S, W, AA etc)

One option is to use conditional formatting.

In G8 go to conditional formatting and enter Formula is
=AND($B8<=$G$7,$D8=$G$7).
Select format | patterns and click a suitable grey.
Copy this formula across row 8 to column K (if you already have data in
the
sheet, you can use Paste Special | Formats)
Edit the condition at K8 to change the references from G to K, but leave
everything else the same.
Copy across to column O and edit O8.
Continue this process across row 8 until you reach BR8
Select G8:BR8 and copy the row down to row 28

I wish to shade to grey, or change to white, cells in a chart from G8 to
BR28
[quoted text clipped - 48 lines]

I hope my comparison logic is correct here (-:

--
Message posted via http://www.officekb.com