conditiaonal formatting

Good time of the day to you all! I have a problem with conditional formatting and really hope that someone could help :) In the below table the formatting needs to be applied to the columns D, E, F and it should be based on the values in columns A & C with the following condition: if cell D4...

It's easy to copy the value of a cell. If you want to automatically copy the value from A2 to B7, then in B7 you type =A2. But can something like this be done with cell formatting? I use a spreadsheet to track our work, and we color each item based on who is handling it (every person is...

Hello, I am trying to do some simple conditional formatting to change the colors of some cells based off the value of one of the others. My "NewRow" variable works for statements before my If statement so i know thats not it. The cell "(NewRow,18)" will be related to a radio button later on so...

All, I have a Pass/Fail column, B. In B2 I have three radio buttons, Pend, Pass, Fail. My need is to 1. Have multiple rows in column B with the same radio buttons. There may be skips. So for example, B2-B10 will have the radio buttons. B11 will not have the radio buttons. B12-B20 will have the...

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...