Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Cinditional formatting question - offsets
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Cinditional formatting question - offsets
On Apr 24, 9:48*am, Pete Rooney
wrote: 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 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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Cinditional formatting question - offsets
Jay,
I owe you my soul. Thank you VERY much! Regards Pete "jlclyde" wrote: On Apr 24, 9:48 am, Pete Rooney wrote: 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 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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Cinditional formatting question - offsets
On Apr 24, 9:48*am, Pete Rooney
wrote: 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 in cell A-1 conditional fomat "formula is" =sum(K1:K100)<0 |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Cinditional formatting question - offsets
But that wouldn't colour the cell if it contained a value of zero. You may
be better with <"" rather than <0 -- David Biddulph "jlclyde" wrote in message ... On Apr 24, 9:48 am, Pete Rooney wrote: 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 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 |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Cinditional formatting question - offsets
Ed,
A nice addition to what I'd already worked out. Thank you. Why didn't I learn about this years ago? :-) Pete "ed" wrote: On Apr 24, 9:48 am, Pete Rooney wrote: 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 in cell A-1 conditional fomat "formula is" =sum(K1:K100)<0 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Countif & Offsets | Excel Discussion (Misc queries) | |||
"internal margin" and axis offsets (excel 2007) | Charts and Charting in Excel | |||
Image (object) offsets in Web show mode | Excel Worksheet Functions | |||
Adding Rows offsets to working rows across two worksheets | Setting up and Configuration of Excel | |||
average, array and offsets | Excel Worksheet Functions |