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
Related:
- Applying conditional formatting to Rows that vary
- How to apply @ in laptop - Guide
- How to apply watermark to all pages in 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)