Conditional Formatting

**AlliePink** · 01-28-2011, 12:54 AM

In column A, I have text, Column B, I have text

I want to compare columns C & E with text in column A
If it matches then in column D, and F, then I would like it to display the text in column b, if not, leave it blank.

Ex.

Column A Column B Column C Column D Column E Column F

Rose 1 Bushes Daisy
Daisy 2 Sunflower Rose
Sunflower 3 Flower Pink

So in column D row 1 & 3 should be blank, but d2 should display the number 3
In column F F1 should be 2, F2 should be 1, and F3 should be blank

**JulieM** · 01-28-2011, 03:19 AM

I don't follow your last paragraph from your initial explanation - you don't appear to have listed anything for a column E to compare with column C, you only seem to have a set of 4 data items (flower, number, flower, flower)?
Why should D2 contain the number 3 when C2 contains Sunflower and E2 is blank (that assumes you haven't got a header row) ?

Perhaps if you uploaded a mini spreadsheet to clarify it might help. Fill in the results you want automatically displayed and highlight those cells

**AlliePink** · 01-28-2011, 09:48 AM

Thanks for taking your time to reply, but no there are no header rows. Of course this just an example, but my excel sheet is a lot more complicated, but once I get the idea, then I can figure it out and test it.

Thanks

**TMShucks** · 01-28-2011, 07:36 PM

It looks as though there IS a header row in your example.

I have to be honest though and say I have absolutely no idea what you are trying to do.

I guess I follow a cow lives on a farm, a dolphin lives in the ocean, etc. And, on that basis, I can understand that next to cow under Compare you have farm ... but how did you get farm for horse?

To get farm for cow, in cell D3, you could just use VLOOKUP: =VLOOKUP(C3,$A:$B,2,False)

That same formula would work if copied to cells F2 and F4.

But why are cells D4, D5, F3 and F5 blank?

There's a whole lot of not understanding what is required going on in my head ;-)

Could you step through your logic explaining what's in each column and why, what you are comparing with what and what the expected results are and why.

I think we need to understand the logic before deciding if a formula is appropriate or VBA.

Regards

**AlliePink** · 01-28-2011, 08:30 PM

Lol, yea nothing I do really makes sense. But the reason why those would be blank is because there wasn't a match in column a. In my example, I did create a header so it would make more sense and easier to view it.

what I am really keeping up with is all my programs and registration information (if it's needed) in excel. My computer just crashed, and I do have an external hard drive, but you can never be too sure.

So Column A has all my programs. Column B has the website where the program can be downloaded from.

Then in Column C, I'm organizing the programs (like office, photo, etc.). So like in column C if I have IrfanView then I want it to see if theres a match in column A, and if so, then Column D, I would Like for it to either Link it to column B, or copy the link name.

So like if IrfanView is in cell A55. But the match in cell C22, in D22, I would like for it to link to B55 (so I can just click on the link) or have the link in D55 to click on.

I hope this makes more sense.

Thanks for responding.

**TMShucks** · 01-29-2011, 03:50 AM

mmm ... that doesn't explian the entry next to horse though. Unless you're trying to shut the stable door after it has bolted.

So, you've done the example with flowers, and you've done the example with animals ... what's so secret about a list of applications?

However, based on what you've said, I think the VLOOKUP is what you need ... try it ;-)

If you want to find out all about your computer, applications and licence keys, you could do worse than run Belarc Advisor:

http://www.belarc.com/free_download.html

It's free and seems to discover an awful lot about your computer.

Regards