IF THEN Statements with color

Copper Contributor



I want to design a statement that says IF A5 =B5, 0,*highlight the cell red. Is that possible?

1 Reply



Do you know about Conditional Formatting? (If it's not clear, that's a hyperlink to a resource regarding conditional formatting)


Having asked that, it's not entirely clear to me what you're actually desirous of doing with that statement. Is it, in words, assuming that statement (formula) is in cell C5,

"If A5 equals B5, enter zero in C5; else, highlight C5 in red."