Applying conditional formatting to Rows that vary

Closed
lynnseyt
Posts
1
Registration date
Friday June 27, 2014
Status
Member
Last seen
June 27, 2014
- Jun 27, 2014 at 06:41 PM
rizvisa1
Posts
4479
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
- Jun 28, 2014 at 08:57 AM
I need to have AA turn red when the date is out of window of AB and AC. I have dates in column AB and AC the dates are all different in each row.

I need to have AA turn red when that date is not equal to or higher than AB and when the date is not equal to or lower than AC.

Example: AB=10-Jun-14 AC=9-Aug-14 If AA were 9-Jun-14 is shold turn red through the formatting.

I know I can do it with a single cell but it doesn't work for whole columns. Any help would be appreciated!

1 reply

rizvisa1
Posts
4479
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
770
Jun 28, 2014 at 08:57 AM
I presume that decision to make cell red or not is based on data on same row. If that is the case, click on cell AA1, then click on column AA. After that write the conditional formula for AA1 as
=OR( AND(AA1<>"", AA1<AB1), AND(AA1>AC1, AC1<>""))
(I have not tested the formula)
0