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
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!
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!
Related:
- Applying conditional formatting to Rows that vary
- How to apply @ in laptop - Guide
- Apply watermark to all pages word - Guide
- How to clear formatting in excel - Guide
- How to apply moderate effect in powerpoint - Guide
- How to change date format in excel - Guide
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
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)
=OR( AND(AA1<>"", AA1<AB1), AND(AA1>AC1, AC1<>""))
(I have not tested the formula)