Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 56
  • 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

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

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