Excel/Conditional Formatting

New Contributor

How can I conditionally format one cell based upon the cell value of a different cell? 

For example I want cell A1 to become red when cell A2 has a given value.


2 Replies

@jdrpdx Use this to conditional formatting rule-







Thanks for your help.  I'll have to experiment with it to be sure I understand how to implement your suggestion.