Cinditional formatting question - offsets

  • Thread starter Thread starter Pete Rooney
  • Start date Start date
P

Pete Rooney

Good afternoon,

I could probably event code do this in VBA if I had more time, but is there
any way of using standard conditional formatting to say "colour this cell red
if the cell 10 coumns to the left contains a value" ?

Thanks in advance

Pete "17:30 deadline" Rooney
 
Good afternoon,

I could probably event code do this in VBA if I had more time, but is there
any way of using standard conditional formatting to say "colour this cell red
if the cell 10 coumns to the left contains a value" ?

Thanks in advance

Pete "17:30 deadline" Rooney
Click to expand...

Yes there is. Select the cell that you want formatted and select
format, conditional formatting. change it to formula is, select the
cell in question then <>0. Pick your formatting and hit ok. Anytime
that the cell does not equal 0 it will color the cell that you entered
the formatting in.
Jay
 
Good afternoon,

I could probably event code do this in VBA if I had more time, but is there
any way of using standard conditional formatting to say "colour this cell red
if the cell 10 coumns to the left contains a value" ?

Thanks in advance

Pete "17:30 deadline" Rooney
Click to expand...

in cell A-1 conditional fomat "formula is" =sum(K1:K100)<>0
 
But that wouldn't colour the cell if it contained a value of zero. You may
be better with <>"" rather than <>0
--
David Biddulph

Good afternoon,

I could probably event code do this in VBA if I had more time, but is
there
any way of using standard conditional formatting to say "colour this cell
red
if the cell 10 coumns to the left contains a value" ?

Thanks in advance

Pete "17:30 deadline" Rooney
Click to expand...

Yes there is. Select the cell that you want formatted and select
format, conditional formatting. change it to formula is, select the
cell in question then <>0. Pick your formatting and hit ok. Anytime
that the cell does not equal 0 it will color the cell that you entered
the formatting in.
Jay
 
Ed,

A nice addition to what I'd already worked out. Thank you.

Why didn't I learn about this years ago? :-)

Pete
 
Back
Top