We have an excel spreadsheet that has conditional formatting on it. When a date exceeds a certain # of days, the cells change color. It works great on one computer. On other computers, the conditional formatting does not work. It is saved on the intranet within the company. What is wrong?

Howdy. How is the conditional formtting done? Is it by VBA code or traditional Conditional Formatting? Do all have the same version of Excel?

It was done in traditional conditional formatting. We are using the same version of excel.

Can you post what you are using for each condition?

If the date exceeds 10 days the cell turns red. When the date is met the cell turns green. Otherwise the date is cell is white.

So, what exactly do you have in the formula for the condition?