Forum Discussion
IF THEN Statements with color
HI! I want to design a statement that says IF A5 =B5, 0,*highlight the cell red. Is that possible?
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."