Conditional Formatting in an 'if' statement

D

dansul

I am trying to have one cell turn red when another cell is
less than a set amount or other cell. Basically, if
cell 'a4' = if('a1'<'a2', 'a5' - black font, 'a5' - red
font).
any ideas using an if statement or should i just implement
this through a macro?

thanks.
 
D

Dan E

If I understand you correctly (which i'm not entirely sure I do)
you want cell A4 to display the contents of cell A5 regardless of
what is in it.

In cell A4 type =A5
(if the font isn't black change it to black)

In the conditional formatting window, put
Formula Is: =(A1>A2)=TRUE
change the conditional format to red font
Hit OK

Dan E
 
D

dansul

That's it - thanks Dan E.
-----Original Message-----
If I understand you correctly (which i'm not entirely sure I do)
you want cell A4 to display the contents of cell A5 regardless of
what is in it.

In cell A4 type =A5
(if the font isn't black change it to black)

In the conditional formatting window, put
Formula Is: =(A1>A2)=TRUE
change the conditional format to red font
Hit OK

Dan E




.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top