Conditional formatting and Inserting Text

Ok I have been attempting to do this for sometime and am at a complete loss.

What I am doing is checking dates, first off the day of the week on a cell above, then I compare it with the due date entered to the right. When the date due is matched up with the day of the week it will change the cell color to red, this was the easy part.

What I also want to do BUT can't is to add a Bold, white letter D at the same time.

For example.

_ |_D__|_E__|_F__|_G__|_H__|_I______|
5 |Jan1|Jan2_|Jan3|Jan4_|Jan5|Date due_|
6 |____|____|__D_|____|____|__jan3___|
7 |____|____|____|_D__|____|__jan4___|
8 |_D__|____|____|____|____|__jan1___|
9 |____|__D_|____|____|____|__jan2___|
10|____|____|__D_|____|____|__jan3___|
11|____|____|__D_|____|____|__jan3___|

Does anybody know if this can be done? I am thinking I need to use an IF formula but I don't know how to set it up. If at all possible in the same formula would be awsome.

Thank plenty

Link S

Copy this formula into D6 and then paste for the entire matrix. Make your conditional format say If cell = "D" the make cell color red. Format the entire matrix to be text-bold and text color-white.

=IF(D$5=$I6,"D","")

Hope this helps!

Rutgers_Excels you are awesome!
Did as you said and it works exactly as I needed it!
*does the cabbage patch*

Thanks again!

Link S