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.