An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.
One of a set of tools we're offering as a way of saying thank you for being a part of the community.
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.
Asked:
2
1 Solution
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.
Join & Write a Comment Already a member? Login.
Featured Post
Tackle projects and never again get stuck behind a technical roadblock.
Join Now
Break it down. Put =X4<>"" in one free call and =Y4="C" in another free cell. What are the results?