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