condition conditional

  1. C

    Setting Conditional Formatting based upon definitions table

    Hi, I'm new to this forum as poster. In the past I was able to use the tips and solutions given here. Thank you for that! Now I have an issue where I could not yet find the answer. I have a sheet which needs conditional formatting. I want to do this with a table where I define all elements...
  2. K

    # Condition is - How to highlight Cell Value via other cell "TRUE" OR "FALSE" value (if "K1" = FALSE after change cell color to Red) (No VBA)

    @ How to change "H2" cell color change After "FALSE" ????????????????????????????????????????????????????????????????????????????????????? (No VBA only for condition formatting)
  3. J

    Counting Unique Values from a Set List Based on Another Cell's Conditions

    I need help figuring out a formula that will allow me to count the number of unique occurrences for a list of values that show up within specific categories. Basically, I have data like this: A B 1 Booking Type Room Number 2 Office Hours 123 3 Office Hours 125 4 Event 200...
  4. X

    Conditional Hyperlink with drop down list

    I have a drop down list with 4 options - A, B, C, and D. I need that only when C is selected from the list, the cell itself has a hyperlink. So, if cell B4 gets the value C from the drop down list, then C or the cell itself should be hyperlinked to say Google.com. If any other value is selected...
  5. S

    Condition based average

    <tbody> 1489534983 -36 -41 -31 -37 1489534983 -38 -43 -32 -36 1489534983 -38 -41 -30 -37 1489534983 -36 -43 -32 -36 1489534984 -36 -41 -32 -37 1489534984 -36 -41 -32 -37 1489534984 -36 -41 -32 -37 1489534984 -36 -41 -32 -37 1489534985 -36 -41 -32 -37 1489534985 -36 -41 -32 -37...
  6. S

    Add amount based on condition

    Hello all. Looking for help. Have a column of units representing weight. Wanting to easily create a new column to represent shipping weight. Would like to know a good formula for adding 50 pounds to any number in the column over its original 100 pounds. Best way to proceed would be? Will...

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