IF function to change color of cell?

[madhatter]

i want to change the color of a cell if another cell has a value of
greater than 12.
what is the input i use in the IF function to change the color of the
cell?
=IF(E3>12, ? , ? )
can someone help me.

thanks

 

[Ruthki]

Could you use conditional formating instead?

select Format, Conditional Formatting from menu

then select "formula is" in box
Type =a1>12
(assuming a1 is your cell with the number in)
any cells formatted like this will change colour depending on the vau
in a1.

you can copy the format to other cells and the reference moves a
normal depending on whether you make it absolute or not ($$)

Rut

 

[Bob Phillips]

You need conditional formatting.

Look up 'Highlight cells that meet specific conditions' in the Answer
wizard in help


--

HTH

RP
(remove nothere from the email address if mailing direct)

 

[madhatter]

i did that, but i think that my cell i am getting my value from i
causing it not to work.

in the cell i am using as a reference for the greater than 12 i
really this function =DATEDIF(B3,NOW(),"m").

how can i get it to take the value that is displayed and not th
function?

my overall goal is to have a cell change color if the date that i
entered is older than a year. maybe you have a better way of gettin
this to happen

 

[madhatter]

i got it, i put =DATEDIF(B3,NOW(),"m")>12 in the conditional formatting
thanks for your hel

 

[Guest]

hi,

is there any function to have > 3 conditional formatting area?

thank,s

"madhatter" escreveu: