Excel help please

[Long John]

I am running Excel 2007 and need help with Conditional Formatting.

In column U, I have data that is either one value or blank. If there is a value in column U, I need the data in the corresponding cells in columns A, B & C to be Italicized or highlighted a different color (either will do).

Anyone know how to do that?

If it helps, I can move Column U to Column A and hide the column.

[revo]

Home/Conditional Formatting/Rules, then just add the simple rule you need. But I'm not 100% sure if you can have it where one cell has the data and another cell gets the formatting.

[TranaGreg]

#3 from this page might help

http://www.techrepublic.com/blog/10t...g-feature/3166

[heyelander]

Home/Conditional Formatting/Rules, then just add the simple rule you need. But I'm not 100% sure if you can have it where one cell has the data and another cell gets the formatting.

You need to set a formula in the cell instead of a "Cell Value is"

SO in each of A,B,C you need to do the conditional formatting, and then set it to Formula and type in U1 = 1 and choose the formatting you want. You could then leave the rest alone or ADD U1 <> 1 some other formatting.

[TranaGreg]

You need to set a formula in the cell instead of a "Cell Value is"

SO in each of A,B,C you need to do the conditional formatting, and then set it to Formula and type in U1 = 1 and choose the formatting you want. You could then leave the rest alone or ADD U1 <> 1 some other formatting.

i think the formula you want to use is =NOT(U1="")

[heyelander]

i think the formula you want to use is =NOT(U1="")

yeah, my <> doesn't seem to work.

[Long John]

Thanks everyone. Much obliged.