Formating cells based on a value

[Meg_meg2]

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

[Meg_meg2]

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 

[lbendlin]

Please provide sanitized sample data that fully covers your issue. If you paste the data into a table in your post or use one of the file services it will be easier to work with. Avoid posting screenshots of your source data if possible.

Please show the expected outcome based on the sample data you provided. Screenshots of the expected outcome are ok.

https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523

[lbendlin]

Please provide sanitized sample data that fully covers your issue. If you paste the data into a table in your post or use one of the file services it will be easier to work with. Avoid posting screenshots of your source data if possible.

Please show the expected outcome based on the sample data you provided. Screenshots of the expected outcome are ok.

https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523