Conditional Formatting- Functions

Originally Posted by jbroad

I am a public health student and am developing an asthma tracking system. I want to set up column F so that if the value is less than 80% of column G the cell will shade yellow, and if it's less than 50% it will shade red. I just need to know how to write the formulas to set those conditions. Thank you, hope someone can help.

Hi,

with column F selected (F1 the active cell)

Data, Conditional Format,

Formula,

=F1<(G1*0.5)

colour for red pattern

add option

Formula

=F1<(G1*0.8)

colour for yellow pattern.

hth
---

Originally Posted by jbroad

Will that apply it to all of the F's, or would I need to set up that formula for every F cell individually?

what did it do?

---

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

---

Try selecting the whole column and then add the conditional formatting


VBA Noob

Originally Posted by jbroad

Got it, thank you very much!

good to see, and thanks for the response
---