Excel Forum

Excel Magic Trick # 270: Conditional Format Based On Diff Cell

See how to create conditional formatting based on a different cell. See how to highlight (add formatting to a cell) a number based on a date in a different cell, and see how to highlight a number based on a name in a different cell. We will use a Logical TRUE FALSE formula to turn on and off the conditional formatting format.

Got a Question? Ask it Here in the Forum.