Solved

Excel - Conditional Formatting

Posted on 2014-09-10
6
67 Views
Last Modified: 2014-09-11
I want to do a conditional rule, but can't seem to get it to work correctly.  I want to compare Column F with Column C.  If Column F does not match Column C, and it is not empty, I want it to highlight red.  Issue is that when the below formula, some of the cells that match the value, it is still highlighting it red.

=IF($c2=$f2, 1, 0)

However, it is highighliting some items that matches as well as blank cells.  Any ideas?
0
Comment
Question by:holemania
6 Comments
 
LVL 35

Expert Comment

by:Kimputer
ID: 40315784
Is it possible you fill an excel file with multiple of these errors, and point then out? Attach the file here?
0
 
LVL 37

Expert Comment

by:Gerwin Jansen
ID: 40315786
=AND($C2 <> "", $C2 <> $F2)
0
 
LVL 4

Accepted Solution

by:
rlarian earned 500 total points
ID: 40315964
Gerwin Jansen has the right answer, with slight modification.

i think F is the column to check for blank.
=AND($F2 <> "", $C2 <> $F2)
0
What Is Threat Intelligence?

Threat intelligence is often discussed, but rarely understood. Starting with a precise definition, along with clear business goals, is essential.

 
LVL 37

Expert Comment

by:Gerwin Jansen
ID: 40316567
Typo, in my test I have the check on empty in F2 :-)
0
 

Author Closing Comment

by:holemania
ID: 40318187
Thanks.
0
 
LVL 37

Expert Comment

by:Gerwin Jansen
ID: 40318229
No split?
0

Featured Post

6 Surprising Benefits of Threat Intelligence

All sorts of threat intelligence is available on the web. Intelligence you can learn from, and use to anticipate and prepare for future attacks.

Join & Write a Comment

Suggested Solutions

A2 = A1 That kind of cell reference is relative.  If you copy it from A2 to B2, then B2 will get this: B2 = B1 That's all fine and good, but if you then insert a new row above row 2, you'll find: A3 = A1 B3 = B1 This is intentional. …
Approximate matching with VLOOKUP and MATCH seems to me to be a greatly under-used technique, and one which is vital for getting good performance out of large lookups. Until recently I would always have advised using an exact match for simplicity an…
The viewer will learn how to use a discrete random variable to simulate the return on an investment over a period of years, create a Monte Carlo simulation using the discrete random variable, and create a graph to represent the possible returns over…
This Micro Tutorial will demonstrate how to use a scrolling table in Microsoft Excel using the INDEX function.

758 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

19 Experts available now in Live!

Get 1:1 Help Now