Conditional Formatting

[Steven]

When I go into conditional formatting I only see how to
format depending on the value of the current cell.

I want to format cell B20 depending on the value in A1.
How do I do this?

Thank you for your help.

 

[Frank Kabel]

Hi
in the conditional format dialog choose 'formula' and enter something
like
=$A$1="value"

 

[Chip Pearson]

Steven,

In the Conditional Formatting dialog, change "Cell Value Is" to
"Formula Is" and enter a formula that return TRUE or FALSE. If
it returns TRUE (or any non-zero numeric value) the format will
be applied to the cell. If it returns FALSE (or a zero), the
format will not be applied.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com