Conditional Formatting Formula

Tony_Manero

New Member
Joined
Jan 22, 2016
Messages
9
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
 

Forum statistics

Threads
1,085,503
Messages
5,384,064
Members
401,878
Latest member
MP_7

Some videos you may like

This Week's Hot Topics

Top