Applying conditional formatting to Rows that vary
Closed
lynnseyt
Posts
1
Registration date
Friday 27 June 2014
Status
Member
Last seen
27 June 2014
-
27 Jun 2014 à 18:41
rizvisa1 Posts 4478 Registration date Thursday 28 January 2010 Status Contributor Last seen 5 May 2022 - 28 Jun 2014 à 08:57
rizvisa1 Posts 4478 Registration date Thursday 28 January 2010 Status Contributor Last seen 5 May 2022 - 28 Jun 2014 à 08:57
Related:
- Applying conditional formatting to Rows that vary
- Excel clear formatting - Guide
- Excel conditional formatting based on date - Guide
- How to delete rows in word - Guide
- Excel conditional formatting dates overdue ✓ - Excel Forum
- How to apply at the rate in laptop - Guide
1 response
rizvisa1
Posts
4478
Registration date
Thursday 28 January 2010
Status
Contributor
Last seen
5 May 2022
766
28 Jun 2014 à 08:57
28 Jun 2014 à 08:57
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)