|
Format cell in column B based on value in the next cell (column c)
I did a basic select all from one application & pasted it into Excel
(starting a cell A1). How do I conditionally format Column C based on the value in Column B? What I'm looking for is: If the row value in Column B = 1, then ident the Column C 1 time. If the row value in Column B = 2, then ident the Column C 2 times. etc. To make things worse: the range of data keeps changing (it may be 200 rows one week & 800 rows the next). |
Hi Nicole
AFAIK you'll have to use a macro for this as conditional formatting does not allow for indents. Is a macro solution acceptable? Cheers JulieD "Nicole" wrote in message ... I did a basic select all from one application & pasted it into Excel (starting a cell A1). How do I conditionally format Column C based on the value in Column B? What I'm looking for is: If the row value in Column B = 1, then ident the Column C 1 time. If the row value in Column B = 2, then ident the Column C 2 times. etc. To make things worse: the range of data keeps changing (it may be 200 rows one week & 800 rows the next). |
Yes - I macro is an acceptable solution. I just need a little help and
sample....PLEASE! "JulieD" wrote: Hi Nicole AFAIK you'll have to use a macro for this as conditional formatting does not allow for indents. Is a macro solution acceptable? Cheers JulieD "Nicole" wrote in message ... I did a basic select all from one application & pasted it into Excel (starting a cell A1). How do I conditionally format Column C based on the value in Column B? What I'm looking for is: If the row value in Column B = 1, then ident the Column C 1 time. If the row value in Column B = 2, then ident the Column C 2 times. etc. To make things worse: the range of data keeps changing (it may be 200 rows one week & 800 rows the next). |
Hi Nicole
here's some sample code, it requires you to choose column C and then run the macro --- Sub indentdata() For Each cell In Selection on error resume next cell.InsertIndent cell.Offset(0, -1).Value Next End Sub --- to use the code, right mouse click on a worksheet tab and choose view code in the VBE window choose insert / module copy & paste the code on the right hand of the screen use alt & f11 to get back to your workbook select column C choose tools / macro / macros find the indentdata macro click run Hope this helps Cheers JulieD "Nicole" wrote in message ... Yes - I macro is an acceptable solution. I just need a little help and sample....PLEASE! "JulieD" wrote: Hi Nicole AFAIK you'll have to use a macro for this as conditional formatting does not allow for indents. Is a macro solution acceptable? Cheers JulieD "Nicole" wrote in message ... I did a basic select all from one application & pasted it into Excel (starting a cell A1). How do I conditionally format Column C based on the value in Column B? What I'm looking for is: If the row value in Column B = 1, then ident the Column C 1 time. If the row value in Column B = 2, then ident the Column C 2 times. etc. To make things worse: the range of data keeps changing (it may be 200 rows one week & 800 rows the next). |
You are AWESOME!!! THANKS SO MUCH.
I didn't think it would be that easy. Thanks again Cheers back at you! Nicole "JulieD" wrote: Hi Nicole here's some sample code, it requires you to choose column C and then run the macro --- Sub indentdata() For Each cell In Selection on error resume next cell.InsertIndent cell.Offset(0, -1).Value Next End Sub --- to use the code, right mouse click on a worksheet tab and choose view code in the VBE window choose insert / module copy & paste the code on the right hand of the screen use alt & f11 to get back to your workbook select column C choose tools / macro / macros find the indentdata macro click run Hope this helps Cheers JulieD "Nicole" wrote in message ... Yes - I macro is an acceptable solution. I just need a little help and sample....PLEASE! "JulieD" wrote: Hi Nicole AFAIK you'll have to use a macro for this as conditional formatting does not allow for indents. Is a macro solution acceptable? Cheers JulieD "Nicole" wrote in message ... I did a basic select all from one application & pasted it into Excel (starting a cell A1). How do I conditionally format Column C based on the value in Column B? What I'm looking for is: If the row value in Column B = 1, then ident the Column C 1 time. If the row value in Column B = 2, then ident the Column C 2 times. etc. To make things worse: the range of data keeps changing (it may be 200 rows one week & 800 rows the next). |
you're welcome and thanks for the feedback
"Nicole" wrote in message ... You are AWESOME!!! THANKS SO MUCH. I didn't think it would be that easy. Thanks again Cheers back at you! Nicole "JulieD" wrote: Hi Nicole here's some sample code, it requires you to choose column C and then run the macro --- Sub indentdata() For Each cell In Selection on error resume next cell.InsertIndent cell.Offset(0, -1).Value Next End Sub --- to use the code, right mouse click on a worksheet tab and choose view code in the VBE window choose insert / module copy & paste the code on the right hand of the screen use alt & f11 to get back to your workbook select column C choose tools / macro / macros find the indentdata macro click run Hope this helps Cheers JulieD "Nicole" wrote in message ... Yes - I macro is an acceptable solution. I just need a little help and sample....PLEASE! "JulieD" wrote: Hi Nicole AFAIK you'll have to use a macro for this as conditional formatting does not allow for indents. Is a macro solution acceptable? Cheers JulieD "Nicole" wrote in message ... I did a basic select all from one application & pasted it into Excel (starting a cell A1). How do I conditionally format Column C based on the value in Column B? What I'm looking for is: If the row value in Column B = 1, then ident the Column C 1 time. If the row value in Column B = 2, then ident the Column C 2 times. etc. To make things worse: the range of data keeps changing (it may be 200 rows one week & 800 rows the next). |
OK. How about this one. I want to conditionally format one cell or a range
of cells based on the condition or value in a totally different cell or range of cells. How would I do that? Like color fill cell C2 yellow if cell H20 equals Y. And macros are OK. I just don't know the terms or commands I would use to program that stuff. Thanks to anyone that can help. "JulieD" wrote: you're welcome and thanks for the feedback "Nicole" wrote in message ... You are AWESOME!!! THANKS SO MUCH. I didn't think it would be that easy. Thanks again Cheers back at you! Nicole "JulieD" wrote: Hi Nicole here's some sample code, it requires you to choose column C and then run the macro --- Sub indentdata() For Each cell In Selection on error resume next cell.InsertIndent cell.Offset(0, -1).Value Next End Sub --- to use the code, right mouse click on a worksheet tab and choose view code in the VBE window choose insert / module copy & paste the code on the right hand of the screen use alt & f11 to get back to your workbook select column C choose tools / macro / macros find the indentdata macro click run Hope this helps Cheers JulieD "Nicole" wrote in message ... Yes - I macro is an acceptable solution. I just need a little help and sample....PLEASE! "JulieD" wrote: Hi Nicole AFAIK you'll have to use a macro for this as conditional formatting does not allow for indents. Is a macro solution acceptable? Cheers JulieD "Nicole" wrote in message ... I did a basic select all from one application & pasted it into Excel (starting a cell A1). How do I conditionally format Column C based on the value in Column B? What I'm looking for is: If the row value in Column B = 1, then ident the Column C 1 time. If the row value in Column B = 2, then ident the Column C 2 times. etc. To make things worse: the range of data keeps changing (it may be 200 rows one week & 800 rows the next). |
Leon
You can use Conditional Formatting to achieve this. e.g. select C2 and FormatCFFormula is: =H20="Y" Select Yellow from the FormatPatterns and OK your way out. Enter Y in H20 and watch C2 turn yellow. Gord Dibben Excel MVP On Wed, 18 May 2005 12:52:04 -0700, "LeonB" wrote: OK. How about this one. I want to conditionally format one cell or a range of cells based on the condition or value in a totally different cell or range of cells. How would I do that? Like color fill cell C2 yellow if cell H20 equals Y. And macros are OK. I just don't know the terms or commands I would use to program that stuff. Thanks to anyone that can help. "JulieD" wrote: you're welcome and thanks for the feedback "Nicole" wrote in message ... You are AWESOME!!! THANKS SO MUCH. I didn't think it would be that easy. Thanks again Cheers back at you! Nicole "JulieD" wrote: Hi Nicole here's some sample code, it requires you to choose column C and then run the macro --- Sub indentdata() For Each cell In Selection on error resume next cell.InsertIndent cell.Offset(0, -1).Value Next End Sub --- to use the code, right mouse click on a worksheet tab and choose view code in the VBE window choose insert / module copy & paste the code on the right hand of the screen use alt & f11 to get back to your workbook select column C choose tools / macro / macros find the indentdata macro click run Hope this helps Cheers JulieD "Nicole" wrote in message ... Yes - I macro is an acceptable solution. I just need a little help and sample....PLEASE! "JulieD" wrote: Hi Nicole AFAIK you'll have to use a macro for this as conditional formatting does not allow for indents. Is a macro solution acceptable? Cheers JulieD "Nicole" wrote in message ... I did a basic select all from one application & pasted it into Excel (starting a cell A1). How do I conditionally format Column C based on the value in Column B? What I'm looking for is: If the row value in Column B = 1, then ident the Column C 1 time. If the row value in Column B = 2, then ident the Column C 2 times. etc. To make things worse: the range of data keeps changing (it may be 200 rows one week & 800 rows the next). |
| All times are GMT +1. The time now is 05:44 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com