Conditional Format for ANOTHER column that contains ANYTHING

[kyleno]

I'm trying to figure out a formula that will conditionally format another column than itself.

Ex.
I would like the conditionally formatted column to be column O but search column L for cells that contains a date between columns K and M. Columns K and M are start and end dates.

The Between option would seem logical but look in a different column.

Any thoughts? Please and thank you.

 

[chrism216]

I'm trying to figure out a formula that will conditionally format another column than itself.

Ex.
I would like the conditionally formatted column to be column O but search column L for cells that contains a date between columns K and M. Columns K and M are start and end dates.

The Between option would seem logical but look in a different column.

Any thoughts? Please and thank you.

In conditional formats, you need to go to "use a formula to determine which cells to format". Write a formula that evaluates to TRUE or FALSE. Click OK and modify the range it applies to.

 

[FDibbins]

Are you looking for the CF to fire if ANY dates are in K and L, or only if those dates fall within a certain range - and what would that range be?

 

[kyleno]

@FDibbins I have something in place to catch anything outside of my date range.

I have tried to use the following formula but it just won't take:
=IF($L$3="*", TRUE, FALSE)

In column O I am using the following formulas:
=IF($L$3="*", TRUE, FALSE): Color Blue
=IF(L3>M3,TRUE, FALSE): Color Yellow
=IF(L3="",TRUE,FALSE): Color Green

I have tried to rearrange these and nothing seems to help.

 

[kyleno]

I figured it out.

I used:
=IF($L$3<>"", TRUE, FALSE)