I have a sheet that is used as a template within a workbook, i.e. any new sheets that rely of the layout get created from the template sheet and the formula/conditional formatting get updated by the code.
Once the sheets are created (there may be multiple), the user can specify which previous...
Hello,
I'm currently using the following CF Rule to highlight cells in two columns that meet a single criteria from a list on another sheet.
=SUM(COUNTIF(C2,"*"&INDIRECT("t_Whitelist[Author-Series]")&"*"))
However, I would like to expand my criteria to only highlight the cells that meet the...
Hi,
I am trying to apply an formula to highlight prices in Columns G, L and Q that are outside +/- a stated percentage of the average value for that price:
Column G
Column L
Column Q
Column T
Row 1
10%
Row 2
A
B
C
Median/Average
Row 3 - Nuts
31
42
32
35
Row 4 - Bolts
11
9
7...
Hello,
I would be really grateful if someone could answer the following
If the TOTAL of two cells is less then the value you of another cell then post cells red, for example;
if A3+A4 is less than C5
turn cells red
thank you in advance
I am using the Sub Mail_Selection_Range_Outlook_Body() from Ron de Bruin to set up a macro to send an email taking the information from several sheets with reports that I have to send and it works pretty well, but the code doesn't allow conditional formatting to be pasted into outlook.
The...
Hi everyone,
I’m new to this forum / VBA and I’m trying to create a code that applies conditional formatting for all columns in every pivot table and refreshes every table in my Excel workbook. I’ve been able to set this up for one pivot table / one sheet but I’m not sure how to change my code...
Hello all,
I have a table (Query 1) which pulls data from an SQL server and auto refreshed every 2 minutes.
This table has rows each depicting a single order with columns showing various information about the order (Value, Status, Allocation etc)
In this table i have a column called "Last...
Is it possible to format cells which contain specific text, for more than 1 instance.
Tried this with formula but no good.
=ISNUMBER(OR(SEARCH("test1",A1),SEARCH("test2",A1)))
Hi I want to highlight multiple cells of text and numerical values with conditional formatting
This is the prompt,
PROMPT: "Highlight only cells that contain numerical value >0"
Logically it will be solved with the "greater than" option then, cell value >0
However the cells sometimes have...
Hi Gurus,
Could you help me simplify below code which I recorded?
Basically, I need to apply these conditional formatting and hoping that the macro will look for Change 1, Change 2 and Change 3 header name and reflect the number format for all tabs (as the column might interchange on the other...
i have a sheet with values in Column D and E
Now, they enter values in E45 and E36
Afterwards, they enter a value on D48 (They should calulate the difference of E45 and E36
The conditional formula should make the cell D56 red if they value they enter is not equal to the difference of E45 and...
Hi there,
I have 5 conditional formats that I need to combine into one.
Conditional format 1 =AND(M$9>=$J19,M$9<$J19+ROUNDDOWN($D19*($K19-$J19+1),0))
Conditional format 2 =AND(M$10>=$J19,M$10<$J19+ROUNDDOWN($D19*($K19-$J19+1),0))
Conditional format 3...
So I have a macro that I released to my coworker to use, however, the conditional formatting won't highlight for her. If I run the macro on my computer, the highlighting works. The conditional formatting is only on one sheet and the formula does not reference another sheet. I don't know if...
Hi guys!
I am making my grant chart to tracking multiple projects. This picture show the total view.
1) There is a way to highlight the entire row if column A contain integer even or odd number only [1,2,3,..]. I don't want them to highlight the row there is not a integer. [1.1,1.2,.. ]
This...
Hi guys,
I have tried to add conditional format with EOMONTH function.
But I'm not sure what I do wrong, they make the condition that I made but not on the last day of month.
In the below picture: The condition should appear on 30Apr and last day of the other month that what I expect.
I have the following.
BC33Pos test (dupes)Other field test34113512B34:C35Expression=IF(COUNTIF($B$34:$B$35,B34)>1,IF(COUNTIFS($B$34:$B$35,B34,$C$34:$C$35,"<>")>=2,TRUE,FALSE),FALSE)textNO
I would expect each cell to be highlighted, however C35 does not seem to be affected.
The theory behind...
Let's say I have a dropdown with two options (A2):
Category 1
Category 2
I also have a range of cells given with different phrases: (A4:C5)
Phrase A
Phrase B
Phrase C
Phrase D
Phrase E
Phrase F
and also a table which looks like this: (A6:B12)
Phrase
Category
Phrase A...
Good morning,
I'm having an issue with setting the formula for my conditional format.
Some background information: I receive a report and copy and paste as values to the right hand side of it. Then I update all the figures with formulas to pull in correct numbers from various tabs. I want to...
I would like to extract the conditional format of a cell from another workbook and programmatically recreate it. Is this even possible?
The workbook in question has many many conditional formats but it would be very difficult to get the right color codes and formulas from so many cells manually...
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.