I have a client that is using version 03 and 07 in their office.
When opening the file in 03 the conditional formatting is not preserved. Is there a way to preserve the formatting regardless of version?
Ex. Pivot table that provides detail on scheduled hours to work per week. If the employee is less than their standard weekly hours the cell will be green but if the employee is over their scheduled weekly hours the cell will be yellow.
Client statement: "The tool I use for the colors is Conditional Formatting and the Conditional Formats do not carry when a user goes from one version to another."
ANY help is greatly appreciated. Thank you in advance!
Bookmarks