turn

  1. G

    Conditional formatting

    I am trying to conditional format a row to accomplish this. I need cell A1 when it contains the text “Sell” to fill color, Cells (A6:A10) to turn lets say Green. Every thing I have tried so far has failed, this is just one of several formulas I have used IF(C6="Sell",IF(B6:B10)) Thanks in...
  2. D

    vba code to update vba code in Thisworkbook

    Good afternoon all! I am working on a workbook where I have been asked to lock down or turn off a lot of items (formula bar, ribbon, headings, tabs, copy/paste, dragging, etc.). I have this working but I have had to go back and do edits and other updates as changes are requested which causes a...
  3. A

    SUBSTITUTE a Blank space...

    If I have a cell with two digits - how can I use the SUBSTITUTE function to add an extra character to make the cell have 3 digits? So a cell with 11 would turn in to 011 or A11 Thanks for your help!
  4. H

    VBA to turn a table into a data connection

    Is there a way to automatically turn a table into a connection based upon the value of a cell? Let me explain. Let's say I have a table called "Employees", i would want to be able to type "employees" into cell A1, run this code, and it would recognize that based upon what I typed into cell A1...
  5. M

    Change Dot to Comma

    Hi I want to find all my dots in my excel sheet and replace them with Comma. I used the macro recorder to try to find a way and got the code below. However it doesnt work, if I have a number like 12345.6789 it will turn to 123456789 after the macro. Anyone knows how to fix it...
  6. C

    Chart Popup

    When user holds cursor over chart and editing pop up appears to teh right of chart. How do I turn that off? As always, your help is greatly appreciated.
  7. S

    Conditional formatting problem

    Hi, I am trying to apply conditional formatting to Cells D4:D80 that would change colour based on the value in each cell being lees than or greater than the previous cell... i.e. if D4 is £25.00 and C4 is £20.00 then i want D4 to turn Green if its less I need it to turn red. I can manage to do...
  8. J

    IF row in table is complete then turn to values?

    Hi, I probably need a for loop for this, I have a table which has the range A1:J500 and a lot of it is formulated. It can get slow after resizing and data increases, so I was wondering thinking I could turn formulas into values once the row is filled and no longer needs changing Would this...
  9. D

    How to empty cell contents after another cell has been changed

    I have a worksheet comprised of columns A, B and C. Column A is the date, column B is the student initials (which are entered AFTER they read the comments), and column C is the instructor comments. The comments in column C for each date are normally at least 2 rows however, they can be as long...
  10. Z

    Turn On AutoCalculations but do not calculate now

    Hi, Is it possible to enable AutoCalculations (after I disabled its) by prevent immediate calculations until normally it would be executed (after some changes in worksheet is done?)
  11. D

    Red text question

    ROUND(MOD((MOD(AVERAGE(U5/W5),365)),30),0)&"D" Is it possible to turn the letter "D" the color red Thank you for your help.
  12. D

    Colour formatting based on Cell values

    Hope you can help I am trying to create a price comparison tool over 3 columns. Column A is the default supplier price and columns B & C are alternative supplier prices. What I would like to achieve is: If the value of Column B2 or C2 is the same as Column A2 turn Cell Amber If the value of...
  13. H

    vba macro to enable 10 outlook rules

    Hi all, I need a help to build an outlook macro so that i can attached it to an outlook button to quickly turn on or off 5 of my selected outlook rules. The requirement is to enable/disable the 5 rules altogether and there is NO need to run the rule in any of the existing folders/inbox when...
  14. R

    VB Code needed for Tab Color

    Hi all, Im not going to pretend that I know VB code but what I am trying to do is take a column of dates E3:E8 and have then turn the tab color yellow if its within a week of the date. So basically if my sheet "test" has a due date thats 3 days from now the tab color will turn yellow to make...
  15. B

    Smart Dropdown Functionality

    Is there any way I can do the following with a drop down list? If not please help me find a way around this! To start off I have a tab with different scenarios - let's say 3 - with an on/off filter for each. So Under each scenario I have a unique drop down list with options "on" and "off" If...
  16. M

    SUMIFS question

    I'm trying to return values from cells that the cell to the left contains specific text, and total them. I'm unsure on how to get this formula to work. I have more than one criteria that needs to be met, and totals for each of those criteria. =SUMIFS(B36:B43,A36:A43, "TURN"...
  17. K

    VBA code to turn volume on, up, down

    I am trying to find some code to turn my speaker volume on, up or down. I am using the Speak function if that has any relevance...... thanks!
  18. M

    How to stop the user for turning on gridlines & headings

    For the workbook I am creating, I am turning off gridlines & headings. However, the user can easily turn them back on by going to the View tab and clicking the check boxes for those two items (I'm using Excel 2016). Is there a way to make it so they CANNOT turn them back on?
  19. S

    INDIRECT reference

    Can't quite figure out what I have wrong here... =INDIRECT("'[O:\OPS\Wdrive\public\Mike Delclos\DE Histories SC\Scott 05_06_34.xlsx]"&B$58&"'!$I1973") ...is the formula I am trying to use in place of... ='[Scott 05_06_34.xlsx]ABQ'!$I1973 The "ABQ" part is what I am trying to turn into a...
  20. U

    Conditional formatting

    Hello, I need assistance with conditional formatting, in cell AZ880 the user will enter a value, I need this cell to turn green if the value entered is equal to the lowest value in either cells AX or AY 880. If the value in AZ880 does not match the lowest value in either cells AX or AY880 I need...

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