have B column turn red on conditional formatting of E column:

[jsharper]

if column E is over 5000 it is set to turn red. I would like the invoice
number in B column to turn red on this same condition. Not able to figure it
out. Please help.

 

[Max]

Apply CF on col B using "Formula Is",
fix the point to col E using the $ sign,
something like this (with B2 active):
=$E2>5000

Any good? hit YES below
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:27,000 Files:200 Subscribers:70
xdemechanik

 

[Bill Kuunders]

select part of column B
with for instance B2 as your top cell
use
"formula is" in stead of "cell value is" in the dropdown
=E2>5000
and set the format