I have a simple table that using conditional formatting to change the background color of cells based on value. This works.
I have a VB macro that exports this table into a Wiki syntax format for posting to a wiki page. I would like to detect the cell's background color and modify my macro to insert the appropriate Wiki markup.
CurrCell.Interior.Color and CurrCell.Interior.ColorIndex are returning a white background for cells that conditional formatting applies a different color to. These variables work fine if I've manually formatted the cell color.
Any ideas how to tell what conditional formatting did through VB?
Thanks, Doug
I have a VB macro that exports this table into a Wiki syntax format for posting to a wiki page. I would like to detect the cell's background color and modify my macro to insert the appropriate Wiki markup.
CurrCell.Interior.Color and CurrCell.Interior.ColorIndex are returning a white background for cells that conditional formatting applies a different color to. These variables work fine if I've manually formatted the cell color.
Any ideas how to tell what conditional formatting did through VB?
Thanks, Doug