conditonal

  1. S

    Dynamic IF formulas

    Hi all, I'm fairly new to excel, so I hope you can help me. I have a large dataset with monthly tracking data. In one of the sheets i perform a lot of "conditional checks" (typically IF formulas). The problem is, that when new variables are added to the data set, the IF formulas refer to the...
  2. G

    need macro for conditional formatting

    Hi, i need to color the lines based on duplicates (in column B) for each date (column C). The duplicates or single data from a day must have an alternating color. Example attached, thank you very much !
  3. ClimoC

    Cancel saving if condition not met?

    Hello, was wondering if I can stop a user from saving the workbook if a condition fails? Easiest condition would be For each c in Range("M6:M1000") If c.interior.colorindex = 3 Then 'Do not allow to save Else 'Allow to save End If Next So in words -...
  4. B

    Conditional Formatting Issues!!

    Hi guys, I'm using Excel 2007 and am having difficulty with conditional formatting using the "format cells based on their values" function. I am trying to copy the conditional formatting to the cells below, referencing the next cell in sequence as I go. I am trying to do this for hundreds of...
  5. P

    Conditional Formatting

    Dear all, For an work sheet I want to set the following conditional format. When a cell shows a specific number then the whole tekst in another cell must become white or invisible. When I set this conditional format, only a part of the tekst in the specified cell turns white or invisible. The...

Watch MrExcel Video

This Week's Hot Topics

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
Top