Hi Guys,

Did a search on Conditional Formatting, but could not find anything to solve my issse, hence this post. Please Help

I have a worksheet with alot of different numbers in it, the numbers are sourced via a forumla as per below,
=(('Sheet1'!A1-'Sheet1'!A2)/'Sheet1'!A2)*123+100

This formula generally yields a value ranging between 50 and 150.
I have then setup conditional formatting on the cell to fill in either red, yellow, green based on a value between 50 and 150.
ie. If less than 100 = Red
If less than 110 > 100 = Yellow
If > 110 = Green

What i would like it to also do is, if the value is less than 50, replace it with 50, and if more than 150 replace with 150.
Is this possible ?

Thanks for the help!