ExcelBanter - Conditional format not refreshing Excel 2007

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Conditional format not refreshing Excel 2007 (https://www.excelbanter.com/excel-discussion-misc-queries/446659-conditional-format-not-refreshing-excel-2007-a.html)

Nikiie

Conditional format not refreshing Excel 2007

1 Attachment(s)

Hi all,
I have a problem with conditional format. In Excel 2010 I’ve made a table where format depends on value from drop down list. In Excel 2010 everything works perfectly.
But in Excel 2007 conditional format doesn’t refresh. I enclose an excel file for detail.
Please help.

All times are GMT +1. The time now is 09:18 PM.