Excel/Conditional Formatting

Question

How can I conditionally format one cell based upon the cell value of a different cell?&nbsp;For example I want cell A1 to become red when cell A2 has a given value.Thanks

harun24hr · Answer

jdrpdx&nbsp;Use this to conditional formatting rule-=$A2&lt;&gt;""&nbsp;&nbsp;

jdrpdx · Answer

Harun24HR&nbsp;&nbsp;Thanks for your help.&nbsp; I'll have to experiment with it to be sure I understand how to implement your suggestion.John&nbsp;

Forum Discussion

Excel/Conditional Formatting

2 Replies