Can I create a conditional format in a cell using a value from an.

thrasher · 02-04-2005, 01:06 PM

I am trying to conditionally format a cell in a column based on a condition
in a different cell in that column. Can this be done?

Dave O · 02-04-2005, 01:06 PM

Yes! However, conditional formatting cannot be evaluated based on
cells in different tabs or spreadsheets.

**swatsp0p** · 02-04-2005, 01:43 PM

use Formula Is: in your conditional formatting. e.g.

Formula Is: =AND(D5>15) and set your desired format options

You can make a fixed reference if you like: =AND($D$2>1000)

Then copy and paste special>formats to other cells in that column.

HTH

thrasher · 02-04-2005, 02:06 PM

How do I do this? I would like a cell in a column to be formatted based on a
condition of a different cell in that column

"Dave O" wrote:

> Yes! However, conditional formatting cannot be evaluated based on
> cells in different tabs or spreadsheets.
>
>

Debra Dalgleish · 02-04-2005, 02:06 PM

Select the cell(s) in which you want the conditional formatting
Choose Format>Conditional Formatting
From the first dropdown, choose Formula Is
In the formula box, type a formula that refers to the cell you
want to check. For example, if the active cell is in row 2,
and you want to check the value in column A: =$A2>50
Click the Format button, and select the formatting for the cell
Click OK, click OK

thrasher wrote:
> I am trying to conditionally format a cell in a column based on a condition
> in a different cell in that column. Can this be done?

--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html