Multiple Conditional Formatting For One Column and a Whole Row

tjverdugo85

New Member
Joined
Dec 7, 2023
Messages
5
Office Version
  1. 365
  2. 2021
Platform
  1. Windows
I have set conditional formatting for Columns A-M based on data from Column D. I have been able to highlight the row red if the award is expired, and the row yellow if the award expires in the same year as Today. I also have been able to highlight data in Column J if the value is greater than or equal to 365.

The issue I am having is keeping the formatting for Column J if the award is also expired or will expire.

1703799456026.png


These are the formulas I have:
1703799549979.png

1703799569306.png
 

Excel Facts

How to calculate loan payments in Excel?
Use the PMT function: =PMT(5%/12,60,-25000) is for a $25,000 loan, 5% annual interest, 60 month loan.
I have set conditional formatting for Columns A-M based on data from Column D. I have been able to highlight the row red if the award is expired, and the row yellow if the award expires in the same year as Today. I also have been able to highlight data in Column J if the value is greater than or equal to 365.
Tick the above two for - Stop if True and check
 
Upvote 0
So I did that. But I need the formatting in Column J (when the value is greater than or equal to 365) to stay the same if the award is current, expired, or will expire.
In that case keep ticks as it is, but move the rule up or down in order of your preference - Top the most prefered.

Try and revert
 
Upvote 0
Solution

Forum statistics

Threads
1,224,823
Messages
6,181,178
Members
453,021
Latest member
Justyna P

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top