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.