Solved

Tricky conditional formatting fomula

Posted on 2016-09-26
5
43 Views
Last Modified: 2016-09-26
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
Comment
Question by:route217
  • 2
5 Comments
 
LVL 23

Expert Comment

by:Erik Bjers
ID: 41816449
0
 

Author Comment

by:route217
ID: 41816462
Not sure I follow on how to do the conditional formatting formula...
0
 
LVL 50

Accepted Solution

by:
Rgonzo1971 earned 500 total points
ID: 41816463
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
 

Author Comment

by:route217
ID: 41816490
Thanks for the excellent feedback
0

Featured Post

Free Tool: Path Explorer

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.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article will guide you to convert a grid from a picture into Excel format using Microsoft OneNote and no other 3rd party application.
Do you use a spreadsheet like Microsoft's Excel?  Have you ever wanted to link out to a non excel file on your computer or network drive?  This is the way I found to do it!
The viewer will learn how to use the =DISCRINV command to create a discrete random variable, use this command to model a set of probabilities and outcomes in a Monte Carlo simulation, and learn how to find the standard deviation of a set of probabil…
This Micro Tutorial demonstrates in Microsoft Excel how to consolidate your marketing data by creating an interactive charts using form controls. This creates cool drop-downs for viewers of your chart to choose from.

830 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question