Excel 97 Conditional Formatting

[BarryG]

I'm trying to format a row based on the value of a cell in one column. I have a column called &quot;Reason&quot; and I want rows to have a different format if the Reason column contains a particular value, such as &quot;days&quot;. I've tried the conditional formula: =reason=&quot;days&quot; but this doesn't work.<br>
Any ideas?

 

[Dreamboat]

Conditional formatting is only good for the contents of the cell(s) selected, not another cell. You may need to do an If statement that formats your cell or use code.

 

[BarryG]

I understand what you're saying, but I'd like to get it to look at the contents of a specific column within each row. In other words, something like:<br>
<br>
if column c of this row contains the value "days", make this cell's fill a different color.<br>
<br>