Aug 2, 2006 · RE: if cell is blank, color another cell? You can use conditional formating (menu Format) in A1, set the condition with "Formula Is" and use the following formula: =ISBLANK …

Jul 5, 2025 · Re: Excel Conditional Formatting Based on Another Cell Your screen shot doesn't show any values in column A which contain "Off". Typically, you would select the whole range …

Aug 29, 2013 · Open both files at the same time Copy the empty sheet (with the conditional formatting) from the first file to the second file Copy all the data you want formatted onto the …

Apr 8, 2021 · Formatting cell (s) based on another cell's conditional format? Hello, If the colour of a number formatted cell is determined by CF based on it's numerical value (say using a 3 …

Oct 9, 2015 · Color scale conditional formatting based on another cell's value In column F, I have a summary total number of customers that will be lost over a certain time at a given location …

Apr 17, 2025 · Re: Changing cell color based on presence of value in another cell. Use Conditional Formatting and choose to use a formula. First select all the cells you want to …

Jul 9, 2020 · The cell styles Male and Female should be created in advance using F11 or Styles -> Manage Styles. Doing so the are available when you define the Conditional Format (The …

Apr 29, 2018 · Re: Conditional format to add borders I don't think conditional formatting is what you need here. If you have a UserForm that is stamping data to the worksheet then have it …

Jan 25, 2022 · Re: Conditional Formatting to Highlight Blank Cells based on the Date in Another Cell Awesome; thank you so much to both of you! I really appreciate your help. Both solutions …

Jan 27, 2017 · Hello, I have a formula in a cell that based on the result, I want to be able to apply a conditional format. I need the formula in the cell to calculate first, then, based on the result …