I can't reconcile your formula with what you say you want to do.
If the condition for A8:G8 to be formatted is that G8=Y, the Formula Is
condition would be =$G8="Y".
--
David Biddulph

"Paul" wrote in message
...
Hi All,

I need to copy the folowwing conditional fromat into my spreadsheet

Formula Is =COUNTIF(A4:G4,"Y")

I want to copy this so if G8= Y cells A8:G8 go grey etc
I have set the format but it wont copy. I have been paying around with the
$ sign but still no joy

My head hurts please help

VMT Paul