IF Cell in column C is highlighted, then cell in column D = cell in column C

[Brooklyn23]

Hi all, please help,

Column C has rows of values. I want to populate column D as follows: IF Cell in column C is highlighted, then cell in column D = cell in column C, else leave the cell blank. Thank you.

 

[RudiS]

Hi,

When you say highlighted are you referring to fill colour? Is there a condition linked to cells that are highlighted? A formula cannot determine cell formatting but it can determine (test for) the value of the cell, so if the colour is due to some condition on the value in the cell the IF() function can work by testing the value of the cell without the need to test the colour. Can you provide more info regarding this?

TX

 

[Brooklyn23]

Hello, I will be back on tonight and supply all the information asked for. Thank you for helping me.

Cross-Post
IF Cell in column C is highlighted, then cell in column D = cell in column C (Excel 2007)

 

[Brooklyn23]

It is highlighted due to conditional formatting.

Conditional formating (already set up) I have two sets of data. If an ID in data set 1 appears in data set 2, then the row in data set 1 gets highlighted.

I then want to take the last column in data set 1 (we'll call it column F), which contains numbers, to be copied to the next column (column G) only if that column F is highlighted (via the conditional formatting). Here is an image:
[TABLE="width: 64"]
<tbody>[TR]
[TD="width: 64, align: center"][/TD]
[/TR]
</tbody>[/TABLE]
http://1drv.ms/1Fnav2y (view picture 1 only)

Thank you.

 

[RudiS]

You can use the same conditional expression from your conditional formatting within the IF() statement. There is not need to test if the cell is highlighted.

For example:
Assume the conditional formatting is set up like this in the F column to test value in A1 with value in I1 (a second data set):
C/F: A1=I1, shade Yellow

Your IF() function:
In column G, type and IF function: =IF(A1=I1,F1,"")

As you can see, the same C/F condition is just slotted into the IF() functions logical test.

 

[Brooklyn23]

I believe that answers my question. Thank you RudiS. Perhaps you can assist in another problem I have (last one, lol). It's actually figuring out the proper conditional formatting that relates to this question. You've helped me figure out the 2nd half to my problem.

Please check it out on this link Right function inside a Match function - highlight based on criteria

Thank you Rudi

 

[RudiS]

Based on the image in the Excel forum you can try a formula like this in the conditional formatting feature.

=COUNTIF($G$5:$G$11,RIGHT($B5,7))>0

G5:G11 are the unique ID numbers. (I recommend that this list contain the ACTUAL "cleaned up" ID numbers WITHOUT any leading zeros.)
RIGHT($B5,7) is the value to search for in range G5:G11
COUNTIF is the condition. If a match is found the logic is >0 and the condition is TRUE

The confition can be applied to the whole table to highlight the row where a match is found, or to the single ID column to highlight only the ID.