conditional rules

  1. C

    Conditional Formatting - Dates

    Hello, I am trying to create some rules where the cells will change colors based on two dates and a running total Month by Year. See Below Expiration Date Commencement Date Jan 2023 Feb 2023 March 2023 April 2023 01/31/2023 04/05/2023 Colored Cell - Expiration Date Colored Cell -...
  2. K

    Applying Multiple Conditional Formatting Rules

    I am applying 4 conditional formatting rules to 184 cells. I figured out how to correctly apply the formula and the colors I want but it is going to take forever doing it one at a time (that's 736 rules). Is there a way to do this more efficiently? The rules for the first cell (O7) are...
  3. E

    Conditional Formating Rule question

    Good morning/afternoon! I am attempting to use to create a Condition Formatting Rule in which if a particular cell has a zero, the following 3 or 4 cells populate with a N/A. When I create the new rule under use a formula to determine which cells to format, I highlight the 3 or 4 cells and put...
  4. SelinaR

    Conditional Formatting - stop if true

    I have created a number of conditional formatting rules for a selected area to format fonts for specific text, however, as soon as theres text typed in that is not in any rule, it makes it red.... how can I stop this from happening? Thanks in adbvance :cool:

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