I have a calculated column with a code that looks at a column with a start date and a column with the current date (what ever day it is) and it calculates the number of days between the two. I want the calculated column to turn the number to red when it is equal to or greater than 90 days. When I do a conditional format in the calculated column it does nothing at all. Why? Is it because the calculated column is a code and not a typed number?
I do not know the answer for certain, but you can create a regular text field that is populated with the results of the calculated column and format that one conditionally.
We use jScript to format this type of thing. It offers more robust formatting options, but of course, you need to know java script. Good luck!
