If Statement Values and Changing Cell Colors Problem

[Harley51]

Here's what I need to do. Using an IF statement enter a number value in cell B8. Enter a number value in cell B28. If they are equal number change font to red. If they are not equal change number font to black. Can someone write it out for me. I have spent days trying to get this to work. Thanks in advance.

 

[WinteE]

What do you mean with "Using an IF statement enter a number value in cell B8." ?

Is this value entered somewhere else or in cell B8 itself ?

 

[Harley51]

I'll be using an If statement in a Macro to check when I enter a number into cell B8. I enter a number into cell B29. If they are equal change the color on the number font in cell B8 to Red. If the number in B28 doesn't equal B8 then leave the number font black.

 

[WinteE]

Use conditional format. Instead of 'Value is' you'll have to use 'Formula is' and enter =B8=B28 .
Add a red color to the font and your ready.

 

[Harley51]

Thank you I'll give it a try. I will need to do this to six times (IE: C8, C28). Do you this as a problem to finihed this statement??

 

[Harley51]

Thank You that worked great.