Conditional Formatting

[Akash]

Hi,

Greetings!!

I wanted to use the conditional formatting tool in a situation but am
not able to understand how to use the same.

I have two column:

In first column (A1) i have dates : 1st Jan 2008
In Second Column (B2) i have month : I have a formula as =A1 and with
the use of Format Cell > Custom > Type > mmm, yy.

Now whatever date in put in A1 the month gets displayed in B2.

I have copied the formula in the Column B. as equal to column A, Now
if my Cell A2 is blank it gives me an output as Jan, 00 in my cell B2

I don't want Jan, 00 to be displayed in my Cell B2 if my cell A2 is
blank.

So i tried using Conditional formatting but it didn't clicked.

Pls do help me regarding the same.

Thanks

Akash Maheshwari

 

[Joel]

Don't use conditional format try this instead in B1

if(A1="","",A1)

the above formula if A1 blank will display nothing, else it will display the
correct results.

 

[driller]

If you like to *display* nothing when A2 is blank by using cond. format tool,

format>conditional formatting>

Condition 1

Cell value is - equal to - 0

format the font color to *white*

then the dispaly is off - only on excel white *background display* sheet.