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).