I have a predasheet which only shows every fourth row, i.e. 1 row shows, 4
rows hidden and so on.

I would like the 4 hidden rows to appear if a condition in a particular cell
is true. For example, if I type Yes into cell C3, I would ike rows 4, 5 and
6 to unhide.

If this is not possible with conditional formatting, can it be done another
way?

With thanks