turn

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...

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...

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!

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...

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...

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.

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...

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...

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...

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?)

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.

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...

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...

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...

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...

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"...

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!

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?

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...

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...