Thankyou to both of you for the replies but it doesnt seem to work.
ill explain a little mo

In Cell C6 To C43 I have This:
='Overdue Review'!A4
'
='Overdue Review'!43
Which basicly looks at a different sheet in my workbook, it is either
a yes or a no.

If this cell equals No then i want it to hide,
If this cell equals Yes then i want it to be shown,

And i was wondering could this be done?