Format cell based on conditional fill color

[Robert_G]

I have one columns that conditionally fills the cell color based on a criteria. I would like the adjacent column to look at the first column and if the color is green, to display a word ex: "go". If there's no fill color, to remain blank.

I've tried defining by name & attempts with VBA, but to no luck.

 

[WassimN]

Hi Robert_G,

Why look at the Conditional Format to populate the "Go" vs. the value of the cell, that triggers the Conditional Format?

So lets say that in the cell that has the Conditional Format to turn in green when that cell has a value of "Ready, Set..." then =IF(A1="Ready, Set...","Go","") should do the trick?

Will that work?

 

[Robert_G]

 

[Robert_G]

I have 2 columns of information. Column A looks at Column D. If the values don't match, it conditionally formats a fill in green. Column D looks at column A. If it doesn't match the same values, it highlights in green as new information.

What I want is to the right of the highlighted cell, is to display another highlighted cell either <<<Tested or <<<Print as shown in B2 & E2. If the cell is not highlighted, to just remain blank to the right of the highlighted cell.

 

[MARK858]

As WassimN has stated it is a simple formula then you can apply conditional formatting as you have done with the values, why do you need VBA?

Formula as below

Excel Workbook
	A	B	C	D	E
2	2			2
3	3			3
4	4			4
5	5			5
6	6			6
7	7			7
8	6			8
9	9			9
10	10			10
11	8			11
12	12			12
13	13			13
Pilots

 

[Robert_G]

This would fine for me but the two rows of information may be in a different order. In conditional formatting, I'm highlighting any cells that are unique between the two columns.

 

[MARK858]

Then as WassimN stated use the same condition that you are using to conditionally format the data. You already have the conditional format rules so just put it in an IF/OR statement.

 

[sunilbsrv2k]

Alternatively, you can use, vlookup with if function to find if the data exists in another table.

Like : =IF(VLOOKUP(F18,B18:B26,1,0), "<<< Tested",0)

You can then add Conditional formatting.

 

[Robert_G]

 

[Robert_G]

I currently have this formula and it's doing what I want except if the cell is blank, I would like it to be blank and not say <<< Print This Record. I just want to reserve that for a field with a value in it. I've tried a couple ideas with no luck.