Dynamic Range setting for Conditional Formating

[vijay.vizzu]

Dear All,


I have just created a dynamic range namely "data" and want to use in conditional formating to adust range dynamically. But i observed that, it not takes range dynamically.


So how to use range dynamically in Conditional Formatting to avoid manually adjustmant of range


thanks

Vijay

 

[Hui]

Vijay


I don't believe it can be done

 

[srinidhi]

Select the entire data, Insert Tab & Table.

In this table you can apply the Conditional Formatting. As you enter new data the table will get expanded & the Conditional Formatting as well.

 

[vijay.vizzu]

Dear Srinidhi,


Thank you so much for your comment, but i just want to avoid using table option.