What I need to do is change the color of the data in a virtual column
[Fuel Amount_s]/[Total Miles_s]
EX: if calculation is <0.59 (GREEN)
If calculation is between 0.60-0.65 (YELLOW)
If calculation is >0.65 (RED)
I used these in format rules Thank you
[Average fuel cost_s]<=0.6 for green
AND([Average fuel cost_s]>0.60 , [Average fuel cost_s]<=0.65). For yellow
[Average fuel cost_s]>0.65. For Red
As far as I know, formatting rules are fixed: they define a color or a font (a rule cannot apply a different color based on a condition).
You can only several conditions to apply one or another rule.
That is to say: you have to create as many rules as colors you want to give. In each rule you must configure the condition and to whom it should be applied.
In your case they will be applied to the same column but the condition of each rule will be different.