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.
route217Asked:
Who is Participating?
 
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.