Conditional Formatting

  • Thread starter Thread starter Steven
  • Start date Start date
S

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.
 
Hi
in the conditional format dialog choose 'formula' and enter something
like
=$A$1="value"
 
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
 
Back
Top