Excel 2013 / 2010 Conditional Formatting

[mattygriff]

I have created a spreadsheet in Excel 2013 which uses conditional formatting to identify the highest and lowest values in a (non-consecutive) range of cells within each row. The highest value cell in each row is given orange fill and the lowest is given green fill.

A colleague has created a copy of this sheet in Excel 2010 and the highest value cell in each row is now given purple fill while the lowest is given orange fill.

I have checked the conditional formatting rules and the colours have been changed to what is showing in Excel 2010.

Grateful for any suggestions as to how we could preserve the original formatting - thanks in advance.

 

[1726]

You can control the Colours used to display the spreadsheet in both versions of Excel:

Look at: File, Options, Save

Here you will find the section entitled:

Preserve visual appearance of the Workbook

Cheers

 

[mattygriff]

Thanks, 1726 - have looked at that but I'm only using standard colours so not sure there's anything I can do there.

 

[Mizzness]

Matty,
Try using the Protect Worksheet function. This will prevent any unnecessary changes from unauthorized users.