Conditional Formatting Formula

[Tony_Manero]

My speadsheet calculates the 15% and 20% weight loss from a start weight and the cells automatically change orange or red

But I also need a formula which calculates the daily change in weight expressed as a % , whether increase or decrease, this can be shown as green cells and ideally when 15% loss or more is entered the cell changes colour to red

So in the attached example cell F22 the mouse has lost 15.9% in a day

https://drive.google.com/open?id=1PE-e3Bv5swswsh5HglVX6R5dQCGxewcJ

 

[aqeelnokia99]

can u explane a little bit more dont understand question