Solved

# Tricky conditional formatting fomula

Posted on 2016-09-26
33 Views
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
Question by:route217
• 2

LVL 23

Expert Comment

ID: 41816449
0

Author Comment

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

LVL 48

Accepted Solution

Rgonzo1971 earned 500 total points
ID: 41816463
Hi,

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

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

Author Comment

ID: 41816490
Thanks for the excellent feedback
0

## Featured Post

### Suggested Solutions

A2 = A1 That kind of cell reference is relative.  If you copy it from A2 to B2, then B2 will get this: B2 = B1 That's all fine and good, but if you then insert a new row above row 2, you'll find: A3 = A1 B3 = B1 This is intentional. …
This article descibes how to create a connection between Excel and SAP and how to move data from Excel to SAP or the other way around.
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 will demonstrate how to use longer labels with horizontal bar charts instead of the vertical column chart.