Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Formating cells based on a value

Dear Community 

 

the situation is as following 

I have a cell that count the difference between the expected delivery date and the actual delivery date;

I would like to flag or highligh cells in red that have a value lower than 7 days 

PS: there are also negative values in the days counted

 

Would you please support on how to flag these cells or highlight them in the visual. I am using a table

 

Thank you and regards

3 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable

    I have values that are between -12 days to n days. the idea here is to format in red any value lower than 10 days and everything else in green