Best way to change color of font in code?

[bobbby1949]

I have a code that converts a number to a smaller number based on various criteria. What would be the best way to show a different color for the font when the code changes the number?

Example: A3 = 8. A 4 = 7. I want to have A4 be 7

Would a conditional format code be best? Or should I use a =IF code?

Here is the current code I am using to determine the affected number:

=IF(OR(D9=""),"",IF($AA9<10,MIN(D9,D$6+2),MIN(D9,LOOKUP($AA9,{0,10,20,30,40},{0,7,8,9,10}))))

Thanks

[jeffreybrown]

Use conditional formatting...

=A4=7 >> Pick format

[bobbby1949]

That won't work because there are several different numbers that may apply.

What I have is:

D8:L8 that have different numbers anywhere from 1 to 20. The code I am using is used in D24:L8 that changes the numbers if the criteria is met. The numbers in D24 row will always be less than what is in the D8 row if the criteria is met, but most of the time it will not change. I want to have the font red when it does change.

If you are a golfer, you may understand that the code is used to meet the ESC requirement in scoring for handicap purposes. The actual number scored is in the D8 row, and the adjusted number is the D24 row. I want to identify when an adjustment has been made using a different color font.

Hope this better describes what I am trying to do.

Thanks

[jeffreybrown]

Do you have a small sample workbook you can post for a visual?

[martindwilson]

=A3<>A4 Perhaps

[bobbby1949]

=A3<>A4 Perhaps

I think that will work. Let me give it a shot.

Thanks