Conditional Formating

  • Thread starter Thread starter Brw
  • Start date Start date
B

Brw

Excel XP
Windows XP

I love the Conditional Formating function (Toolbar: Format
| Conditional Formating)

However, is there any way to set a Conditional Format on a
cell or selected area of cells based on the results of
cell OUTSIDE this selected area or cell?

i.e. I want cell A:1 to have a yellow background if cell
B:10 is "10".

Brw
 
Brw said:
Excel XP
Windows XP

I love the Conditional Formating function (Toolbar: Format
| Conditional Formating)

However, is there any way to set a Conditional Format on a
cell or selected area of cells based on the results of
cell OUTSIDE this selected area or cell?

i.e. I want cell A:1 to have a yellow background if cell
B:10 is "10".

Brw
Click to expand...

Yes. When you select A1 and go to set up conditional formatting, use the
drop-down arrow to change "Cell Value Is" to "Formula Is". Then in the box
alongside this, you can enter a formula. You would need:
=($B$10=10)
Then choose your yellow formatting just as you are used to doing.
 
In the Conditional Formatting dialog, change "Cell Value Is" to
"Formula Is" and enter a formula that returns TRUE or FALSE. If
the formula returns TRUE, the format will be applied to the cell.
If the formula returns FALSE, the format will not be applied.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
 
Select A1, use formula is and

=$B$10=10

click format and select colours and click OK twice
 
Back
Top