Conditional formatting for excel is always disappearing (compatibility mode)

Can you attach a sample workbook showing the issue?

Go Advanced -> Manage Attachments -> Upload

When I try and save the file I get this message;
Capture.JPG

Hmmm, let me upload a newly created one.


Thanks.

It's the same due to the compatibility issue.

that's really weird let me start again from scratch.

Here it is. Thanks

I have uploaded another version. Here I have completed the first "Employee". Lets say he selected salary grade A on the drop-down box.

I have highlighted the Intermediate, Advanced and superior column as it is not applicable for him on the "Division 1" as it is not applicable for him.

This will be true to other succeeding divisions. Problem is there are at least 30 divisions, and with each different "Areas", some might have only 1 areas. It will be very time consuming to apply the CF

in each boxes and sometimes when I open my saved file all my hard work is gone. The CF's just vanished.

Is there any way to highlight the boxes, or locked them, any alternatives or suggestions?

Thank you.

The problem is that you save the files with compatibily mode as .xls that fileformat will not support the conditional formatting of Excel 2007 and onwards with the introduction of .xlsx files also the conditional formatting was changed completely.

Be aware, while you have the .xls file open your current Excel version will allow you to set CF but as soon as you try to save (again) as .xls it will be removed.
You are allowed to create because you are in a version that works. compatability only means that you can save the file in a format that users with the older versions can open and use them
Non-existing functionallity cannot be supported by the older version.

Thanks,

What if I created it on .xls from scratch instead of xlsx?

I think that might work. but I'm not 100% sure.