JXL: can I create a conditional format on whether a specific cell has been edited?

Question

My team is enjoying using JXL :)

It would be incredibly useful for us to be able to see if certain fields (date fields) have been changed in the last X number of weeks.

I see there is a conditional format option available for when an Issue has been edited but we need this to be more specific i.e. specific fields within the issue.

We have various delivery date fields which either denote when a client needs to deliver to us or when we need to deliver to them - however if the client is late then all the dates need to shift and various teams need to be alerted.

Is there a way for changes to these fields to be highlighted for certain amounts of time so they flag up on the various JXL reports we have?

Thanks!

Lois Taylor · Answer

Thanks Daniel sorry for the slow response - will get in touch now!

Daniel Franz - JXL · Answer

Hi Lois – Welcome to the Atlassian Community and thanks for your question about JXL. Conditional formats in JXL sheets can be applied to individual fields and table columns. Could I ask you to get in touch with us about the above at https://support.jxl.app so that we can look into it together in more detail?

Thanks!
Daniel