looping thru a range to hide where cell = #N/A and conditional formatting

hi, hope someone can help.

In the attached example workbook i have a number of sheets, and i want to create a macro which will against "Analysis 1", "Report 2" and "Report 3" only but ignore the other sheets.

Running against rows 7 to 26 only....
1. Where column O contains an #N/A i want to hide the row, else show the row.
2. For each cell in colmns C7:N26 if the value is below the row cell in Q then format the cell as green, if above the value in row Q then format the cell red.

Hope this is do-able.

thanks for your help.

Try this.

rgds

johnjohns

Dear Johnjohns and Domski, many thanks for your help, both examples are perfect.
thanks so much.

Luce

Domski's aproach is but faster, better and easily modifiable. I preffer that to mine.

rgds

johnjohns