[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 69
  • 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 HensonIT & Database AssistantCommented:
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 HensonIT & Database AssistantCommented:
Out of interest, and completeness for the thread, what was the issue in the end?
0

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering 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