Lookup

[wcurtis]

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

 

[Mike H]

Hi,

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

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

Mike

 

[wcurtis]

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