Simplest Condition Format Problem!

K

kpark91

Well-known Member

Joined

Jul 15, 2010

Messages

1,582

• Aug 13, 2010

• #2

So if A1 is blank
and in B1 I have = A1 (in B1, it's going to appear 0)

How do I fill B1 as red? (there might be 0 value inputted in A1 tho!)

 

Upvote 0

N

njimack

Well-known Member

Joined

Jun 17, 2005

Messages

7,772

• Aug 13, 2010

• #3

2 options:
=A1=""
or
=LEN(A1)=0

EDIT: didn't see your 2nd post. If A1 contains 0 then it's not blank. Try one of:
=OR(A1="",A1=0)
or
=or(LEN(A1)=0,A1=0)

 

Upvote 0

VoG

Legend

Joined

Jun 19, 2002

Messages

63,650

• Aug 13, 2010

• #4

Try this

Excel Workbook
	A
1	11
2
3	w
Sheet2

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
A1	1. / Formula is =ISBLANK(A1)	Abc

 

Upvote 0

K

kpark91

Well-known Member

Joined

Jul 15, 2010

Messages

1,582

• Aug 13, 2010

• #5

Thank you for the answers :D

It does what it does half the time.

Perhaps, I have not explained enough.

I have two worksheets (Sheet1 and Sheet2)

Sheet2 cells are purely referring to Sheet1 containing many values (including 0)
Sheet2 refers to Sheet1 cells correctly but when cell in Sheet1 is blank,
in Sheet2 it says 0 instead of a blank cell.


I want to indicate on Sheet2 that the cell it's referring to in Sheet1 is blank

Thank you so much for your answers
but a little more then it would be perfect.

Many thanks

 

Upvote 0

RoryA

MrExcel MVP, Moderator

Joined

May 2, 2008

Messages

42,353

Office Version

1. 365
2. 2016

Platform

1. Windows
2. MacOS

• Aug 13, 2010

• #6

Cross-posted here, BTW.

 

Upvote 0

N

njimack

Well-known Member

Joined

Jun 17, 2005

Messages

7,772

• Aug 13, 2010

• #7

The only way you're gonna do this is with a helper column, using the ISBLANK formula that Peter posted. You can then use Conditional Formatting to test whether ISBLANK is returning TRUE or FALSE>

 

Upvote 0

K

kpark91

Well-known Member

Joined

Jul 15, 2010

Messages

1,582

• Aug 13, 2010

• #8

rorya said:

Cross-posted here, BTW.

Click to expand...

Am I not allowed to cross-post???

 

Upvote 0

RoryA

MrExcel MVP, Moderator

Joined

May 2, 2008

Messages

42,353

Office Version

1. 365
2. 2016

Platform

1. Windows
2. MacOS

• Aug 13, 2010

• #9

You are, but it is courtesy to tell people you have done so by providing links. In some forums, you would get your post blocked, but we're a little more lenient here!

 

Upvote 0

K

kpark91

Well-known Member

Joined

Jul 15, 2010

Messages

1,582

• Aug 13, 2010

• #10

rorya said:

You are, but it is courtesy to tell people you have done so by providing links. In some forums, you would get your post blocked, but we're a little more lenient here!

Click to expand...

Oops! I'm sorry for the cross-post

I was just too eagered/selfish for a solution that I hadn't realized I've done disrepspectful thing.
I really didn't mean anything by it.

I shall give links if I cross-post again

 

Upvote 0