Oct 10, 2012 · Hi, I'm having difficulty with conditional formatting on cell ranges with reference to another tab. Conditional formatting is used on tab 1 which displays some data from another tabs.

Sep 27, 2024 · In conditional formatting, how do I identify cells that are blank to contain a specific formatting, i.e. I want to highlight all blank cells in a column?

Aug 5, 2012 · I’m trying to use a formula in conditional formatting to make a cell (O8) change its fill colour when: The values in two other cells (M8+AB32) added together exceed the value in the cell …

Nov 17, 2015 · After you have done that, select AH2, click on the Format Painter, and select the rest of the cells in AH that you want the conditional format to apply to. That should do it.

Sep 9, 2020 · Copy conditional formatting from one worksheet to another I'm working on a big project in which I have created a "master" excel template for my users to copy and use for their offices. This …

Jul 19, 2010 · I'd like to know how to move rows to another worksheet if a cell of a determined column indicates a certain value (e.g. action done). Thanks!

Oct 3, 2011 · I am trying to copy conditional formatting and have the correct relative/absolute references in my formula. I have also cleared any existing conditional formatting from the range I'm trying to …

Feb 1, 2020 · When referencing a cell on another sheet in the workbook it returns a 0 I have a workbook with several sheets. I want to reference a cell from Sheet 1 on Sheet 2. I am using the formula …

Apr 2, 2015 · And so on. I'm trying to do this for a workbook with multiple worksheets of monthly values for mutual funds I own and another workbook (single worksheet) that shows asset allocation. So to …

Jan 21, 2011 · Hello, I would like to have one cell show the text contents of two cells from another sheet. On sheet 2 I have a cell that I would like to show the contents for Cell G2 & G1.