Text to Text Conditional Formatting

[rpthorsen]

Hello all, I'm new to the site, but have had many solutions in the past come from here.

I am currently working on a tool for my workplace where I use conditional formatting.
My first challenge was to have row colors change according to todays date, but managed that.
My second challenge was to render the first color mute if new information had been input, and managed that as well.
I've also added drop-boxes and filters, so I wouldn't call myself an excel newbie, but what I do seem to have problems with is conditionally formatting text in one cell based on the text of another.

I am sure there is probably a simple solution (function) to this, but I would be lying if I said I've read up on my excel formulas lately.

I was also wondering if it was possible to add another dropdown box within a conditional formatting.

The set up I am running now is as follows:

[TABLE="width: 500"]
<tbody>[TR]
[TD]Project
[/TD]
[TD]Primary Filter
[/TD]
[TD]Secondary Filter
[/TD]
[TD]Transmittal
[/TD]
[TD]Date Sent
[/TD]
[TD]Date Due
[/TD]
[/TR]
[TR]
[TD]C1
[/TD]
[TD]160515
[/TD]
[TD]HS
[/TD]
[TD]515-HS-0005
[/TD]
[TD]29.04.13
[/TD]
[TD]13.05.13
[/TD]
[/TR]
[TR]
[TD]C2
[/TD]
[TD]160587
[/TD]
[TD]-
[/TD]
[TD]587-0002
[/TD]
[TD]10.09.13
[/TD]
[TD]24.09.13
[/TD]
[/TR]
[TR]
[TD]C3
[/TD]
[TD]160417
[/TD]
[TD]SCI38
[/TD]
[TD]417-0001
[/TD]
[TD]18.09.13
[/TD]
[TD]02.10.13
[/TD]
[/TR]
[TR]
[TD]C4
[/TD]
[TD]160473
[/TD]
[TD]B21
[/TD]
[TD]473-2002
[/TD]
[TD]09.08.13
[/TD]
[TD]23.08.13
[/TD]
[/TR]
[TR]
[TD]C3
[/TD]
[TD]160417
[/TD]
[TD]SCI38-1
[/TD]
[TD]417-I-0001
[/TD]
[TD]18.09.13
[/TD]
[TD]08.10.13
[/TD]
[/TR]
[TR]
[TD]C1
[/TD]
[TD]160515
[/TD]
[TD]GS[/TD]
[TD]515-GS-0012
[/TD]
[TD]26.09.13
[/TD]
[TD]26.09.13
[/TD]
[/TR]
[TR]

[/TR]
</tbody>[/TABLE]


So as you can see, there are quite a bit of information here.

The drop-down boxes in the project column allows me to select the correct project, but I was a conditional formatting rule to change the primary formatting to the correct number.
Also, if there would be an oportunity to change the secondary filter to a drop-down box so to select the correct portion of the project would be awesome as well.

As I said, I do not need cell or font color changes, that is allready taken care of.

Thank you

- rp

(Oh, I am using Excel 07)

 

[Joe4]

Welcome to the Board!

The drop-down boxes in the project column allows me to select the correct project, but I was a conditional formatting rule to change the primary formatting to the correct number.
Also, if there would be an oportunity to change the secondary filter to a drop-down box so to select the correct portion of the project would be awesome as well.

If I understand you correctly, it sounds like you are not looking to change the formatting, but rather the contents of a cell. Is that correct?
If so, you would NOT use Conditional Formatting to do that. As its name implies, Conditional Formatting can only change formatting of a cell, not the contents.

Perhaps what you are looking for is a VLOOKUP formula, where you lookup some value and return another value based on that lookup. Take a look at Excel's built-in help files for explanations and examples of how this works.

If I have misunderstood your question, please try to clarify it, maybe walk us through an actual example with the data you posted.

 

[rpthorsen]

Yes you are most likely correct. I am NOT trying to format the cell. Do you perhaps know how I would formulate this VLOOKUP formula?

 

[Joe4]

Did you look at the documentation/example of the VLOOKUP function?
Take a look at it, and give it a shot. If you run into troubles implementing it, post back here withe the specific details of what is tripping you up.