Dear visitor, despite the COVID-19 outbreak, our team continues operating at full speed.

Also, here is the form where you can apply for a special discount and we will contact you with possible options. Stay safe and continue achieving your business goals.

Fill the form
Get Free Trial
Get Free Trial

How to make conditional formatting in time cell

long yu asked on July 19, 2019

I have a column with time (00:00:00) and I want to do a conditional formatting (have color for example) but for now, I can do that just for the column with number. Can you tell me how can I make my time with color ?
Best regards,
Cécile Wagnon, Axialys

1 answer

Vera Didenko Flexmonster July 19, 2019

Thank you for your question.
Our team kindly suggests specifying the time data type for the time field. Fields of type time are considered as numeric data and, hence, conditional formatting can be applied. 
Please see the following JSFiddle example for illustration.
Also, we would like to mention that even though it is not possible to highlight a text field via conditional formatting rules, this can be achieved with the customizeCell() API call.
Here is a JSFiddle example for illustration.
Please let us know if you have further questions.
Best Regards,

Please login or Register to Submit Answer