Hello,

I'm trying to replace an area of a sheet based on some condition.

For example, if condition A, then use this table that is 20 rows by 6 columns, with specific colours, and bolded headings, etc. On another condition, same sized table but it looks a bit different.

Looking @ conditional formatting, doesn't seem to be ideal for this.

Is there an easier way?

Regards,

Sanjay