Conditional Formatting Help when a Cell is Blank

N

Nickle

I am trying to format a cell that has three scenario's.

1. If A1=B1, then the text will be green
2. If A1 does not equal B1, then the text will be red
3. If B1 is empty/blank, then A1 has no formatting.

The value of B1 is dependant on a value that is selected from the Master
Sheet. So B1 has a formula that is attached to it.

I am having difficulties getting A1 to have no formatting if nothing has
been filled/selected for B1. Any ideas would help.

Thanks
 
E

Eduardo

Hi,
in conditional formating enter

=AND(B1<>"",B1<>A1)

then set up the colour to be red
 
E

Eduardo

Hi Nickle,
try this, open a new workbook, in cell a1 enter conditional formating, where
the formula is, type the formula, ok, then open the conditional formating
again and check that the formula is exactly the same I has sent to you, if
you see " at the beginning or end of the formula delete it
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VBA Coding Help for Beginner 0
Conditional Formatting Formula 3
Referencing the values of multiple cells in conditinal formatting. 0
Conditional Formatting help (2003) 1
Conditional Formatting with 3 Criteria Options 5
can a cell be both input and output? 3
If Not blank - Formula for two cells 0
Conditional Formatting 1

Top