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 4478 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 response

rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
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