Lookup

W

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
 
M

Mike H

Hi,
Is there a way the change the font color witin a lookup formula?
Click to expand...

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

Mike
 
W

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
 
Top