View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Max Max is offline
external usenet poster
 
Posts: 9,221
Default have B column turn red on conditional formatting of E column:

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

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.