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.

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
---
"jsharper" wrote:
> 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.

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

--
Greetings from New Zealand

"jsharper" <(E-Mail Removed)> wrote in message
news:957354ED-11E0-4154-8EFB-(E-Mail Removed)...
> 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.