VBA to increase the height & cond. format of the current row

[inddon]

Hello There,

I have made a conditional formatting for the current row to be bold in a table.

I am looking for the following to have for the current row selection within the table for better visibility:

1. to increase the height of the row to x cm
2. make the current row bold
3. to have a light grey colour as background. A few columns have it own colour, and those cells/columns should retain its original colour.
4. When the user goes to the next row, the previous row accessed should get back its original row height.

Could you please advise, how this can be done in VBA?

Thanks & regards
Don

 

[Somendra Misra]

Hi DON,

See the file, it uses VBA+CF to achieve what is being done in the file.

Regards,

 

[inddon]

Hi DON,

See the file, it uses VBA+CF to achieve what is being done in the file.

Regards,

Wow! that works so good, thank you

There is a minor change needed. I have certain header rows with different row height from row 1 to 5th. When the code fires it makes all the rows the same row height size to 15.


Could you please advise, how this can be avoided, such that it only increases the current row height to 20?


Thanks & regards
Don

 

[inddon]

Wow! that works so good, thank you

There is a minor change needed. I have certain header rows with different row height from row 1 to 5th. When the code fires it makes all the rows the same row height size to 15.


Could you please advise, how this can be avoided, such that it only increases the current row height to 20?


Thanks & regards
Don

Hello Somendra,

Commented out the statement of row height to 15, in hope it will work. Now it makes the rows all to 20, except for the header rows

Please advise.

Thanks
Don

 

[Somendra Misra]

@inddon

I knew you will write back. I am working on it. Can you upload a file with a sample table of varying row height.

Regards,

 

[Somendra Misra]

@inddon

See the file now.

Regards,

 

[inddon]

@inddon

See the file now.

Regards,

Hello Somendra,

Your solution works perfect in your attached workbook.

I implemented your code in my workbook, but it makes the data rows to height 20. I have attached the workbook for your reference.

Could you please review and advise.

Many thanks
Don