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.
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.
Who is Participating?
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.
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.
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.
Break it down. Put =X4<>"" in one free call and =Y4="C" in another free cell. What are the results?