I am using formula in conditional formatting to highlight cells of date which is of lesser than 7 days of Today's date.
I want a formula that it should highlight the color of dates which is of more than 7 days and and less than or equal to 10 days which will...
I'm looking to Conditionally Format a cell using a formula for another cell if it does not contain certain letters.
I need to conditionally format Cell B1 to be a certain color if Cell A1 does not contain "T","TC","M","MC","B", or "BC".
So when I type in anything other than those...
0 down vote favorite
i want to make a macro that by any change in cells run automatically, so i write below code for my sheet
<code> Private Sub Worksheet_Change(ByVal Target As Range)
Dim KeyCells As Range
Set KeyCells =...
I have to solve this, I know answer can be time consuming but if you have time and nerves your help will be great.
so, I have
cell Value 'error' or 'OK'
and a button 'execute'
Conditions for button when cell value is
Button stays inactive
I have been working really hard to make a spreadsheet super user-friendly for an office manager. The last thing I want to do, I can't seem to find when I Google it. What I have are 2 tabs: INPUT and LOGS. The INPUT tab is for doing just that: input the information and it will populate into the...
This is my first post into this forum. I am trying to follow the rules as best as I can. If I miss any, please let me know.
Idea: I set up a range of cells to show a form when they are double clicked. This form gives the user the choice to pick a color and text from a list. When the...
I want to click on a cell and have the color change. There is a cell range I want this to be in and not the whole work sheet.
I have some code which was given to me but doesn't include a range. and I want a different color but having a hard time finding the color codes.
If I could have...
I found this place that has a macro button that does something similar to what I want to do. I am able to adjust everything to suite my file perfectly so far except one thing. I am trying to get the color change to be based off of another cell, not a set value...
Thank you for your help in the past!
Step 1: In cell B1, my VBA puts the # of the current month using MONTH(TODAY()). This can change if you know a better way.
Step 2: In column B2:B20, there are random 3 letter months
B2 = FEB
B3 = MAR
B4 = AUG
B5 = FEB
B6 = DEC
B7 = JAN
B8 = AUG
B9 = JAN
I am using an Excel Form, and trying to make the user choose a color for a new tab they are creating. I am currently forcing an input box to pop up when the user adds a new worksheet. The user inputs a name and a new box will pop up asking the user to select a color.
I can get the color box to...