I need a the cell that my lookup formula is in to turn red if a number in a
different cell is negative.
Example:
C179 = -26
Cell C182 = $2587.00 but needs to be red because, if
C179 is = +26
C182 = $2587.00 and needs to be green.
I hope that makes sense.

Thanks

"Mike H" wrote:

Hi,

Is there a way the change the font color witin a lookup formula?

Almost certainly with the use of conditionanot l formatting. What are the rules
for coloring the numbers red?

Mike

"wcurtis" wrote:

Is there a way the change the font color witin a lookup formula?
I have 15 numbers and need 7 of those to be red.

Thanks