Conditional Formula modification - 80% of rather than simply less than

[RodneyC]

I'm using this formula =$D6>$E6 to color the font red if the condition is met. This works but I need to change it so rather than simply looking to see if D is great than E, I want it to look and see if E is 80% or less of D. How do I change the formula to show that?

Thanks in advance

 

[etaf]

you want to only test if E is exactly 80% or less than 80%

=E6/D6 - will give the % of E v D

then
=($E6/$D6 )< = 0.8

 

[Micron]

try =$E6<=$D6*0.8

 

[I_know_nuffin]

I'm using this formula =$D6>$E6 to color the font red if the condition is met. This works but I need to change it so rather than simply looking to see if D is great than E, I want it to look and see if E is 80% or less of D. How do I change the formula to show that?

Thanks in advance

try
=(E1/D1)<= 0.8

 

[RodneyC]

Micron's was the first I saw and it works perfectly, thank you

 

[Micron]

You're welcome.