Cover red text with black?

[hallingh]

Is there any way to black out a cell that has red text so it doesn't show the text at all? I figured there would be a way to put the black background on top of the text (essentially making it a black foreground,) but I can't find the option anywhere. If anyone has any suggestions I would be greatly appreciative. Thanks!

Hank

 

[shg]

Make the text black?

 

[GTO]

Is the text red because of formatting, or is it actually that the font is red in the cell?

 

[hallingh]

The text is red because of conditional formatting, and I reaaally don't want to have to edit that repeatedly.

 

[shg]

Why not integrate the condition that makes the cell black into the conditional formatting?