Calgarypuck Forums - The Unofficial Calgary Flames Fan Community - View Single Post

Boblobla · 01-30-2016, 08:41 AM

Here is my issue. I have one column (column A) that has a Y or N in it (for yes or no...) and another column (column B) that requires a value if column 1 has a Y. Is there any way to get the cell in column B to highlight if they are blank AND the column A value is Y?

I have consulted the internet and played with if() statements along with conditional formatting and I can't get it to work. I need something like the following but can't figure out how to get it to work.

if(A1="Y" and B1="blank", change cell color of B1 to red, do nothing)

I am not sure if excel can do this...

Please help me CP, you are my only hope.

01-30-2016, 08:41 AM	#1
Boblobla Franchise Player Join Date: Apr 2008 Location: Calgary Exp:	Alright Excel Gurus... Here is my issue. I have one column (column A) that has a Y or N in it (for yes or no...) and another column (column B) that requires a value if column 1 has a Y. Is there any way to get the cell in column B to highlight if they are blank AND the column A value is Y? I have consulted the internet and played with if() statements along with conditional formatting and I can't get it to work. I need something like the following but can't figure out how to get it to work. if(A1="Y" and B1="blank", change cell color of B1 to red, do nothing) I am not sure if excel can do this... Please help me CP, you are my only hope.