Quote Originally Posted by jbroad
I had to change the formula for each cell so far... is there a way to write a formula with so it applies to all those in that column... =Fn<Gn*.5 or something like that.
It was originally written to apply to the whole column

Select Column F with F1 being the Active Cell (the odd coloured cell)

Data, Conditional Format, Formula, =F1<(G1*0.5) colour for red pattern
add option
Formula, =F1<(G1*0.8) colour for yellow pattern

and that applies to the column

---