I have added some conditional formatting to a spreadsheet and it is working perfectly. (I am setting the background color of cells based on the value of the cell.) However, when I save it as pdf, the colors are not right.
Example of the problem: when a value = 0, the cell background should be white, but in the pdf it is light green. Please look at the tab named "% Variance from Forecast".
Note that I added some test data on the xlsx to show the full range of colors that the condition are set to show. These rows are not in the PDF.
I have attached a sample of each format.
I am using version 22.214.171.124.