I have a table designed in Excel Template. I have to apply conditional formatting for a column which is based on the value of another column (this column is not displayed in the table at all as its not required to be displayed). So how can I do conditional background color formatting for a column which is based on another column which is not in display.
Can we do something to solve this using the XDO_METADATA sheet, Any help please , Guide me..
Thanks in Advance