Conditional Cell Formats-Colors

  • Thread starter Thread starter Cindyjk
  • Start date Start date
C

Cindyjk

I want to format a cell based on a condition in another cell. For
example, I'm in cell C6. I want the number in C6 to appear in a
certain color BASED ON if Cell A1 is either one or zero.
Conditional Formatting doesn't help me here, because the if-then
conditions used in the Conditional Formatting commands are referencing
the cell where I write those commands (i.e., cell C6), not another cell
(i.e., A1).
Any ideas? Thanks Much!
 
One way:

Select C6, choose Format/Conditional Formatting, and use the dropdowns
and textboxes in the CF dialog to set

CF1: Formula is =(A1=1)
Format1: <color 1>

CF2: Formula is =(A1=0)
Format2: <color 2>

if A1 can only be 1 or 0, drop the CF2 and format C6 with color 2.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Conditional formating more that 3 cells 2
Overwriting Conditional Formatting 2
Cell Formatting with a macro... 1
Condition formatting based on other cells values 3
Conditional Formatting help... 3
Using Conditional Formatting to Color Cells 6
conditional formatting - color 3
Conditional Formatting 2

Back
Top