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

T

thrasher

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?
 
D

Dave O

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

thrasher

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
 
D

Debra Dalgleish

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
 
Top