• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 77
  • Last Modified:

conditional formatting formula error

Hi Experts using excel 2010

I have the following formula applying to cell U4

=And(X4<>"",Y4="C")
In cell X4 I have a date in the format 12/04/16 and cell Y4 text C..

Cannot get the CF to work.
0
route217
Asked:
route217
  • 2
1 Solution
 
Missus Miss_SellaneusCommented:
Is it giving you an error? What are the data types for X4 and Y4?

Break it down. Put =X4<>"" in one free call and =Y4="C" in another free cell. What are the results?
0
 
route217Author Commented:
Solved
0
 
Rob HensonFinance AnalystCommented:
If you copy the whole formula into a spare cell, the result has to be TRUE for the CF to work.

I suspect the issue is with cell Y4, if the cell has "C" and leading or trailing spaces comparing to just "C" will give False result.

If X4 contains anything, date or other value, checking against <>"" will give TRUE.
0
 
Rob HensonFinance AnalystCommented:
Out of interest, and completeness for the thread, what was the issue in the end?
0

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

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