Select the cell(s) in which you want the conditional formatting
Choose FormatConditional 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: =$A250
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