Conditional Formatting - Based on other cell Value/format?

[Cerestes]

Afternoon,

Second question of the day regarding conditional formating...

Is it possible to alter the format of a range of cells (using conditional formatting) based on a value/format in another cell?

I have two columns (A/B) which turn dark red if column B>A.

I would like conditional formatting to turn column C to AO the same color if B>A.

Unfortunately, I can only seem to get the format to work based on the value of the specific cell in column C to AO.

Thanks!

 

[yee388]

...so I did.

Yeah - I think that VBA is the way to go. I hope the next release of Excel has more than 3 crummy Conditional Formatting options!

 

[Cerestes]

The ISTEXT command is what I was looking for, thanks for both of your help =)