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

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.



"Akash" wrote:

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

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

formatconditional 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.

--
regards,



"Akash" wrote:

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