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

  • Thread starter Thread starter jsharper
  • Start date Start date
J

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.
 
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
 
Back
Top