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