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

Tricky conditional formatting fomula

Hi Experts Using Excel 2010

Need a formula which looks at two dates and if the text values in cell F2 is not a C then colour cell yellow. I have the following in the CF how do you add the if statement.

AND(C1>=A1,C1<=B1)
0
route217
Asked:
route217
  • 2
1 Solution
 
Erik BjersPrincipal Systems AdministratorCommented:
0
 
route217Author Commented:
Not sure I follow on how to do the conditional formatting formula...
0
 
Rgonzo1971Commented:
Hi,

pls try
IF(AND(C1>=A1,C1<=B1,F2<>"C"),TRUE,FALSE)

Open in new window

or

AND(C1>=A1,C1<=B1,F2<>"C")

Open in new window

Regards
0
 
route217Author Commented:
Thanks for the excellent feedback
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.

Join & Write a Comment

Featured Post

Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

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