|How can conditional formatting rules be applied to cells containing formulas in macro enabled workbook?|
I have a column with each cell having formula, this formula results in either of 3 values viz "1","2","3". I wish to apply conditional formatting or any other tool which would directly highlight each of values with different color code.
The normal conditional formatting works perfectly in such case but it does not work in macro enabled file
Thanks in advance !!
message edited by Vipul07