Red text question

[DDH]

ROUND(MOD((MOD(AVERAGE(U5/W5),365)),30),0)&"D"

Is it possible to turn the letter "D" the color red

Thank you for your help.

 

[Joe4]

Not by formula. Excel formulas can only return values to the screen, they do not affect the formatting.
The way to control formatting is via Conditional Formatting, or through VBA.
But I don't think you can use Conditional Formatting to format just part of the entry. So I believe doing what you want would require VBA.

 

[Fluff]

On top of what Joe4 has said, you would also need to convert the formula into a value

 

[DDH]

Joe4 & Fluff - Thank you for your reply.
I almost thought it was not possible but I thought I would ask the question anyway.

Thank you for your help.

 

[Fluff]

You're welcome