How do i fill one column based on another?

  • Thread starter Thread starter aapp81
  • Start date Start date
A

aapp81

Hello :D
I have column F; each is filled w/ text. some of the cells in tha
column are filled w/ the word "Legal" however - and they are sporadic
Then, I have column Q. Q is generally empty unless column F say
"Legal", then that's the only time that I put something in Q (such a
"lawsuit", "ag", etc...). However, these columns are thousands of row
long and I know that I skipped some of the "Legal" in F and thus, neve
putting anything in Q.
Therefore, I need a function that says something to the effect of:

if F = legal and Q = empty then put an "X" (or something) in Q
else leave blank, unless Q has already been filled by either "lawsuit"
etc...
Thanks
 
1. Select a cell in the table, and choose Data>Filter>AutoFilter
2. From the dropdown in cell F1, choose Legal
3. From the dropdown in cell Q1, choose (Blanks)
4. Select the visible cells in column Q
5. Type an X, and press Ctrl+Enter
6. To remove the Autofilter, choose Data>Filter>AutoFilter
 
Another way is to use conditional formatting.

In the first data cell in column Q i.e. Q3 enter the following

Formula is =AND(F3="legal",Q3="") hit the format button an
choose a highlight colour

Paste format to the rest of column Q

This will then highlight the cell if empty when the corresponding cel
in column F has legal in it. This can then be used as a prompt to ente
your text ie lawsuit, ag etc

If text is already entered into the Q cell it will not be highlighted.

Hope you find this useful

Mik
 
Freemini said:
*Another way is to use conditional formatting.

In the first data cell in column Q i.e. Q3 enter the following

Formula is =AND(F3="legal",Q3="") hit the format butto
and choose a highlight colour

Paste format to the rest of column Q

This will then highlight the cell if empty when the correspondin
cell in column F has legal in it. This can then be used as a promp
to enter your text ie lawsuit, ag etc

If text is already entered into the Q cell it will not b
highlighted.

Hope you find this useful

Mike *
Click to expand...

there's a problem now though... it worked the first time i tried it bu
now what it started doing is when i apply to the rest of column Q, i
DOES highlight the cells if there's "legal" in F but it delete
whatever i already had in Q. and like i said, only some cells wer
missed, i don't want to have to redo the whole thing..
 
Adam
you should be using the format painter to copy the format to the othe
cells, or Copy>Paste special>formats

Hope this cures it

Mik
 
ok... it "worked"
i went to format menu - conditional formating - selected formula from
the drop down and typed in the one you gave me. i did this for column
Q. what i mean by it "worked" is that it highlighted only the cells in
Q ABOVE the "legal" cells in F... i feel i'm getting closer :D
 
Back
Top