I have two tables in one sheet. I combine parallel data from both of them into a third table.
If a cell in table one >0 I want to color the parallel cell in table 3.
<colgroup><col width="64" span="5" style="width:48pt"> </colgroup><tbody>
Table 1
table 2
Combined
5
100...
Hi,
Bit lost with this.
I have a column L whose cells contain the dropdown options
Almost Certain (5)
Likely (4)
Possible (3)
Unlikely (2)
Rare/Remote (1)
Based on what is selected in column L, I want the corresponding cell dropdown list in column M to populate using following rules -
If L...
Hi,
I have a file 7000 rows which contain text. There's more than one sentence in the cell.
I would like to format text in a cell like; All sentences Bold, except in parentheses. Sentences in parenthses will be Italic-not bold.
How can I formulate this issue and apply all rows? Please help...
I have the worst luck when trying to remember how to type formulas for Conditional Formatting. They have subtle differences from the same functions used elsewhere in Excel.
I'm trying to do a simple conditional formatting for a cell that has a number in it. The number is manually typed in, it...
I am wondering if its possible to change the text orientation when a cells that are grouped are minimized/maximized.
Basically I have merged several vertical cells and have the text orientation for those cells as "90" degrees. Now these rows are grouped, and if I minimize the grouping, the text...
Hi All,
Im going to record a macro to light specific cells in excel using conditional formatting.
for example, I want all cells in the J column to be highlighted if they are above 20000.
The problem is is for some of the data it is split, so the combined values need to be combined if there...
Hello,
Please see my coding below. I can't get the formula in pink text to work. I would like the macro to apply a conditional formatting of red text to Column G if any of 4 specific columns contain a value that is equal to or in between input Values Cutoff 1 and Cutoff2.
For example, there...
Hi,
I'm wanting to format cells in worksheet 1 to insert a hyperlink in a cell if a cell in worksheet 2 is not blank.
I also want to color the cell at the same time if the cell in worksheet 2 is not blank.
where do I start with this formula?
I have a worksheet that has 3 tables, each table is auto populated from a raw data import. I have figured out a way to do conditional formatting on one cell now I need a way to copy that formatting to 108 other cells with it updating the cells without creating 324 more rules.
The formatting...
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.