Hi all.
Quick question.
I have conditional formatting on one cell that looks at a value and gives it a colour based on if it's <, = or> then 0. So:
=Language!I5<0
=Language!I5=0
=Language!I5>0
This applies to one cell =$K$3
My issue is that I want this to apply to =$K$3:$K$42 (easy part) however I cannot get it to inc-count the formatting value with either the format painter or the paste special options. That will increase the range of cells that the formatting applies to but NOT what cell it's looking at to get the value.
so
=Language!I6<0
then
=Language!I7<0
Any ideas?
Quick question.
I have conditional formatting on one cell that looks at a value and gives it a colour based on if it's <, = or> then 0. So:
=Language!I5<0
=Language!I5=0
=Language!I5>0
This applies to one cell =$K$3
My issue is that I want this to apply to =$K$3:$K$42 (easy part) however I cannot get it to inc-count the formatting value with either the format painter or the paste special options. That will increase the range of cells that the formatting applies to but NOT what cell it's looking at to get the value.
so
=Language!I6<0
then
=Language!I7<0
Any ideas?