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
Bookmarks