IF function with conditional formatting

[AmazingRandom]

I have been asked to prepare a table where values who surpass a threshold (1800) or equal to it are to be highlighted, as well as have any value less than 1800 to be represented as <1800 while still keeping empty blank cells blank. I know conditional formatting can easily get the 'highliting' I need but since I need to format the < into the cell, would it still be doable? 

From my understanding I need to use a IF funtcion to get IF('data'[value] < 1800, "<1800", 'data'[value]), would that work? Or would I need to also mention the empty cells? And how would that affect the IF function? As the data would be refreshed

[FreemanZ]

hi @AmazingRandom ,

please prepare a sample data with enough complexity and with your expected result. 

[AmazingRandom]

Would a screenshot work? Or you need it in a csv/xlsx file?

[FreemanZ]

hi @AmazingRandom ,

come and check this:

https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-...

[AmazingRandom]

Threshold	Lab Result 1	Lab Result 2	Lab Result 3
1800	<1800	2000	3000
900	2000	<900	1200
360	390	500	<360
180	<180	700	<180

That is an example, the threshold also varies from the sample size used in the testing.