Hi, as mentioned in the title, I'm trying to make a conditional formatting rule where if a cell contains a certain word (potentially in amongst other text in the same cell), the whole row of that cell will be highlighted. Unfortunately I cant quite get the formula right, so looking for...
I am trying to apply the following conditional formatting to a macro. It is creating the formulas and applying them to the correct range, but it is only setting the format for the first formula. Any ideas?
This is my code:
Sub CondishFormatMulti()
Dim MyRange As Range
Set MyRange =...
I have a table where each row is a specific Individual ID Number, and each column corresponds to different dates a test was taken for that ID Number. The ID Numbers are in Column B, and the test dates go from Column H to Column AL. Column H is the baseline test, then every test after that is...
I have a bank report where I am trying to highlight the duplicates. The highlight duplicates only works for one condition under conditional formatting. How do I get it to work for more than one condition?
In my example, I want to highlight duplicates that are duplicates in the Type column and...
I have an Excel sheet that tracks the amount people have paid each week. I'm trying to make it so that the person's name is highlighted in red if the amount of their remaining balance is greater than it should be. I have no problem doing this portion. My problem lies with the upcoming weeks. If...
I use excel and i have sheet look like :
A B C
1 3927269 58516305
2 2356361
3 2749088
4 294545
5 13156350
6 1570908
7 1963634
8 5105449
9 3632724
10 3141815
11 7996358
12 3534542
13...
A kind soul yesterday helped me with a formula for a vehicle maintenance sheet yesterday. I have an additional request.
Can someone please help me out with a formula that gives an "MOT due in..." time, but takes into account the fact that an MOT is only due after 3 years? I have added a date of...
Hello,
I need some help trying to figure out this conditional formatting. I've tried looking at other formulas and implementing them to my situation to no avail. I have the conditional formatting set up as to have anything that is greater than the max ID to go red, however if the max ID cell...
Hello Experts
I Have below Data , i want to give a condition for Jan-23 to May-23
condition Jan-23 - if Jan-23 is greater than Average of Oct-22 to Dec-22 then it's upper direction if not then lower direction
for Feb-23 - if Feb-23 is greater than Average of Nov-22 to Jan-23 then it's upper...
Hello,
I'm having some trouble combining two Conditional Formatting rules to work across two columns instead of using them individually.
Currently, I'm using the following to highlight the cells in the Author and Series columns based on a named range (lstPreferred):
Used in Author column (D)...
Hi folks,
need some expertise to handle a cell that has both positive/negative values and colour the portion of it.
attached is an example.
so, a Cell has a string and number, I want the colour green if it is increased and red if decreased. I am doing it manually and it takes ages. any...
Hello everybody and you all do an amazing work. I need your help please and i apologize in advance for any mistakes (English is not my native language).
This one is kinda tricky and complicated.
I have created a calendar of shorts, where I input the work schedule and put a bunch of conditional...
allow to enter value in cell, only if
1. data contain 1 time "x" value between two numeric value . & both numeric values should not be more than 99,
e.g
34x45.5, (allow)......
21x56.44 (allow)
23c45.5, (not allow).
23 x 45.5 (any space not allow)
101x22 (numeric more than 99 not allow)
I have a Power Automate flow running that adds rows of Associate information into sheets of an Excel online spreadsheet. I would like to set up conditional formatting so that it highlights rows that have the same "Associate Id#" (First column in each sheet) when that ID number occurs three...
I have a spreadsheet I am working on and I need it to highlight cells depending on data from other cells. Here is an example to make it clearer:
I want cell D4 to highlight yellow if the following conditions are met.
If B4 is greater than C3 and less than E3 turn D4 yellow.
Is it possible to...
i have this table:
2022-101
101
1
2022-pzl
101
1
2020-201
102
1
2020-202
103
1
1
101
102
103
i want to conditional format Row 6 if the matching value in column b (ex. 101) is populated in column c and d even if on different rows. (ie: 101 yes,102 no, 103 yes).
i have...
Hi,
I have two separate questions.
1. How would I go about having my matrix quadrants auto-populate once the quadrant is identified on the associated table? I have written several formulas, but keep receiving duplicate "Goals" appear. I have added a second matrix to my workbook to...
Hi. I am struggling to find a way to create multiple drop downs that use just two columns. Using the data below for example, I need the first drop down to select the type of food. The second drop down to filter the colour. Without having to rearrange all the data. (I have 1000s of rows of data...
Hi guys am looking to code in a condictional formatting to a newly created sheet via vba
This intales highlighting the row orange when you click on a cell between a certain range(Any range will do ill edit it to what i need)
i would just set it up when i use it my self manually but unfortantly...
🤓 Good day my fellow nerds,
I need help so I came here to see what Master Nerd could be so kind to solve this issue I am having.
What I am trying to do:
Using Conditional Formatting, I would like the = function to pull text from one cell to another based on a Start Date.
Example:
Text in...
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.