I am trying to find a formula that allows me to do the following in order:
1) If the group ID is the same AND (2) if the Part # is the same as the (3) Part # with the minimum group price, highlight this.
For example below, I want to highlight part # MPN1 because it is has the same GroupID and...
Hi. I would like to have conditional formatting done on an Excel Table based on the MIN and MAX values of every row in the table. Cells of the MIN values are to be highligted in RED with WHITE font. Celss of the MAX values are to be highlighted in GREEN with WHITE font.
I was able to find VBA...
Hello,
I've created a weekly planner for revision, it has a start date, duration and % completed. The dates are in columns eg 29/03 am and 29/03 pm...
It's all great when i enter the duration as 1 day and it highlights both AM and PM for that day. Can anyone tell me what is the conditional...
I have searched the web for a solution to my question with no luck. Here is my issue:
I have cell A1 with a date (any date), I also have two named ranges. One named Holidays and the other one named Payroll. They are used to identify the company's holidays and the payroll dates.
I need to...
Hello guys
I wasn't expecting to post a question here, but here it is:
related to another post here (https://www.mrexcel.com/forum/excel-questions/1090639-formatting-cell-value-based-another-cells-colour.html) I decided to make a small UDF to determine the color of a cell.
At first it all went...
Hello
I have an spreadsheet and in a certain row I want to add some of the numbers together, I only want to add together the numbers that are bellow 20 and are conditional formatted to turn green. Is there a formula for this? Thank you
GentlePeople,
I have a Question about How to get my "month" selection to automatically increment +1 for each new month?
I have a few different ways that I have thought it should work, but doesn't.
<tbody>
Circle the Month:
1
2
3
4
5
6
7
8
9
10
11
12
</tbody>
This is the way the month...
Hi guys, if anyone can help me get the macro for this to work, it would be amazing!
My VBA is lacking a little and am losing my head over this - any help would be greatly appreciated:
'if any cell value in range L3 to P73 is = 2 in the OLD v New Check Sheet
'then find corresponding cell in...
Hello Mr. Excel Members, I'm hoping someone can help me format numbers based on text. Scenario:
Cell A1 contains 5 unique names in 'text'. (Price, ACV, Units, etc.)
If A1 contains the word 'Price' I want the number in B1 to be formatted as currency ($00.00)
If A1 contains the word 'Units' I...
Column K has values that may contain a "✓".
When a ✓ is present, I would like the row that the ✓ is on to highlight between Column A and J.
I'm not sure how to carry out the process all the way down the document, 2000 rows or so.
Thanks for any help.
K4=✓, So highlight A4:J4
K72=✓ A72:J72
So, in other words:
I have cells that contain text strings.
The text strings may or may not contain numbers.
In the event that they DO contain numbers, I'd like to set up some way to automatically make JUST THE NUMBERS bold. \
Is this possible? Either via Conditional Formatting or VBA?
Thanks!
I have searched for this. I have tried to retrofit other conditional formatting threads. I thought I was close but couldn't get it to function. I figure this is easy and I am just on brain melt.
I am trying to make a dynamic shift calendar and when someone changes the operator who is on...
I have a ODBC query where I want to highlight certain rows when a cell contains the number 1. This last cell is outside of the ODBC query.
So far I cannot get the whole row to highlight only one cell. Any help would be greatly appreciated.
Thanks
Jim S.
I am trying to format cells based on a calculated percentage. It's a very simple calculation, =K2/J2 which produces a % value. When I apply a conditional formula, of any kind, it only recognized the data as the most complete value in the condition, i.e., 100%.
I've done some simple test...
Hi Community,
i'm needing some help with a Conditional Formatting using a IF statement. Here is what i have so far:
Column A: Name Of Customer (A1-Bob, A2-Sally etc.)
Column B: Date last contacted Customer: (A1: 09/01/2018, A2 10/01/2018)
I am trying to Conditionally format for the date...
I’m looking to do some conditional formatting on the excel app for iPad Pro as in being able to autocapitalize and change fill color based on what letter is typed in to given cells.
Is that possible on the app for excel?
Does that require an Office 365 subscription?
Any help would be...
(Excel 2016) I have a row of cells that 'vlookup' values from another workbook. I want to conditionally format cells that have a minus value, the same as I have in other parts of the sheet. However, I cannot get these particular cells to format. I'm obviously missing something. Any help would be...
Hi,
Can somebody please lend their knowledge to help me fix a small issue. I have two columns of GPS coordinates values. I need a conditional format to check a couple of thousand numbers to know whether their are any duplicate coordinates. For the values to be duplicates they have to be...
Hi,
I am just after a little help in fixing a formatting rule that I have written as a conditional format that I have written for QA work. Here is the code I have written:
=OR(AND(SEARCH("missing",K1),M1="No"),AND(SEARCH("lost",K1),M1="No"))
Basically I want the format to highlight when a...
I have a row of values B:W that I would like to highlight if they sum up to a value in column A. And copy that row CF to 600 rows below. A visual of how many days it took a product to sell through.
<tbody>
sales units
1/1/18
1/2/18
1/3/18
1/4/18
1/5/18
1/6/18
22
10
24
9
18
29
4
45
9
19...
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.