If Then Else Highlight

[jerylupe]

I have searched the forum and the internet, but all I have found is conditional formatting which does not appear to do what I want. I have a column into which either a "Y" or "N" will be placed and if "Y" I would like a highlight of the adjacent cell as a reminder for me to do a follow up.

Right now I am using a simple =IF(h2="n","-"," ") to auto fill a dash in the adjacent field as there is nothing left for me to do, but by leaving blank, it is hard sometimes within the sea of data on the page to quickly identify the items that need a follow up. Wanted to make it highlight so that it really stands out.

Looking for something like =IF(H2="n","-",highlight cell red), but can't figure out the RGB code or whatever I need to input to get the color. I may be going about it entirely wrong, so coming to you guys for help again.

Any help is greatly appreciated. Thanks.

Edit: not sure if it matters, but want to do it this way so that once I do my follow up... I will be entering a Y in that field which will replace the formula, therefore, removing the highlight.

 

[mukesh098]

You can do it with VBA

 

[jerylupe]

You can do it with VBA

Thank you, but I don't know how to use VBA other than creating macros... If I am even thinking of the correct thing.

 

[mukesh098]

Show me the data, probably I can help.

 

[AlanY]

the attached file shown CF, set for Column D that can be duplicate for other columns.
have a look to see if it works for you

https://drive.google.com/file/d/0B1h-Y2fdTl08Q3N0ckl6SzdfWWc/view?usp=sharing

 

[oldbrewer]

Y	blah
N	blah blah
		B1 is red
		conditional formatting formula
		=A1="Y"

<colgroup><col span="7"></colgroup><tbody>
</tbody>

 

[oldbrewer]

Y	Y
N	blah blah
		B1 is red
		conditional formatting formula
		=A1="Y"
		re read your post so changed it to
		=AND(A1="Y",B1<>"Y")
		the Y in B1 is not now coloured red

<colgroup><col width="64" span="7" style="width:48pt"> </colgroup><tbody>
</tbody>

 

[mukesh098]

.