LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Nicole
 
Posts: n/a
Default 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).

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Can you conditional format based on information in cell comments? Jflyer Excel Worksheet Functions 1 January 15th 05 01:52 AM
I want to format a cell based on an adjacent cells value Cumbo Excel Discussion (Misc queries) 1 December 13th 04 11:52 AM
GET.CELL Biff Excel Worksheet Functions 2 November 24th 04 07:16 PM
Returning a Value to a Cell Based on a Range of Uncertain Size amc422 Excel Worksheet Functions 7 November 14th 04 03:03 PM
How to populate column with formula based on value in cell Cameron Stewart Excel Worksheet Functions 2 November 2nd 04 01:36 AM


All times are GMT +1. The time now is 05:04 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"