A
Ann Scharpf
I am clearly not understanding how to use the formula in
conditional formatting. Here is what I am trying to do:
Cell B10 copies the value from Sheet2!Z100. If Sheet2!
Z100 is blank, then B10=Average(B7:B9). I am trying to
highlight B10 if is is using an average rather than a
real value.
My actual formula in the cell is:
=IF('Actual TS Hours'!Z20>0,'Actual TS Hours'!Z20,AVERAGE
(B4848))
I went into conditional formatting, selected "formula is"
and entered:
=AVERAGE(B4848)
What's happening is that ALL the cells are highlighted,
whether or not they are equal to the average of the
previous three cells. I tried to really force a false
condition and changed the conditional formula to:
=SUM(B4848)
The cells STILL stayed highlighted.
I have tried looking in help and can't find any guidance
on this. Can anyone enlighten me?
Also, is there a way to SEARCH on this newsgroup? I
could not find a way, so I just paged my way through lots
of pages to see if this question had already been
addressed.
Thanks for any help you can give me.
Ann
conditional formatting. Here is what I am trying to do:
Cell B10 copies the value from Sheet2!Z100. If Sheet2!
Z100 is blank, then B10=Average(B7:B9). I am trying to
highlight B10 if is is using an average rather than a
real value.
My actual formula in the cell is:
=IF('Actual TS Hours'!Z20>0,'Actual TS Hours'!Z20,AVERAGE
(B4848))
I went into conditional formatting, selected "formula is"
and entered:
=AVERAGE(B4848)
What's happening is that ALL the cells are highlighted,
whether or not they are equal to the average of the
previous three cells. I tried to really force a false
condition and changed the conditional formula to:
=SUM(B4848)
The cells STILL stayed highlighted.
I have tried looking in help and can't find any guidance
on this. Can anyone enlighten me?
Also, is there a way to SEARCH on this newsgroup? I
could not find a way, so I just paged my way through lots
of pages to see if this question had already been
addressed.
Thanks for any help you can give me.
Ann