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.

Thanks

2 Replies

@jdrpdx Use this to conditional formatting rule-

=$A2<>""

Harun24HR_0-1663036193564.png

 

 

@Harun24HR 

 

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

John