Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 80
  • Last Modified:

Excel - Conditional Formatting

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
holemania
Asked:
holemania
1 Solution
 
KimputerCommented:
Is it possible you fill an excel file with multiple of these errors, and point then out? Attach the file here?
0
 
Gerwin Jansen, EE MVETopic Advisor Commented:
=AND($C2 <> "", $C2 <> $F2)
0
 
rlarianCommented:
Gerwin Jansen has the right answer, with slight modification.

i think F is the column to check for blank.
=AND($F2 <> "", $C2 <> $F2)
0
VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

 
Gerwin Jansen, EE MVETopic Advisor Commented:
Typo, in my test I have the check on empty in F2 :-)
0
 
holemaniaAuthor Commented:
Thanks.
0
 
Gerwin Jansen, EE MVETopic Advisor Commented:
No split?
0

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now