Conditional Format

[MACY8167]

I am using the below formula to notify of when a change is made.
=IF(AND(R2="LEX",CS2>$A$2,CS2<$A$3),"Change"," ")

This formula looks at cell R2 to see if the text is "LEX". Then Cell CS2 contains a date. The formula checks to see if the date in CS2 is between the dates in cells A2 and A3. If all is True "Change" is entered in the column with the formula

I would like to change it to a conditional format and change the format of cell R2 instead. I guess I don't understand how things need to entered into a conditional format because nothing is working. Any help would be greatly appreciated

 

[Jonmo1]

Conditional formatting formulas do not need to be structured as an IF..
Because CF is already an IF by default.
If the formula is TRUE - change the color, If the formula is FALSE - Do nothing.

So you're formula needs to be structured only to return TRUE or FALSE...
The AND function does just that, returns TRUE if all conditions are met, otherwise FALSE

Try
=AND(R2="LEX",CS2>$A$2,CS2<$A$3)

Hope that helps.

 

[MACY8167]

Thanks for your help! This worked
=(R2="LEX")*(CT2>$A$2)*(CT2<$A$3)

 

[Sharpedge]

That helped me doing a search for answers.

Thanks