excel - How to set cell color based on another cell color - Stack …
Jun 23, 2020 · For conditional formatting, you can just mark the entire column and use the formula for the very first cell. Excel will then automatically assume that you mean the cell in the same …
(Excel) Conditional Formatting based on Adjacent Cell Value
47 I'm trying to apply conditional formatting in Excel on a range of cells, based on the adjacent cell's value, to achieve something like this: The goal is to highlight values in Column B (Actual …
excel - How to add icon conditional formating based on another …
Mar 7, 2021 · I would like to add an icon to cells based on rule if another cell contains a value. Here are cells which I want to format. On the left side I want to add icon in the right side of the …
Format cell color based on value in another sheet and cell
Jan 16, 2009 · I would like to format the cell background color in the first column of sheet 1 based on the values in the second column of sheet 2. For example, if the value of of sheet2, row 6, …
Conditional Formatting based upon format of another cell
Mar 2, 2010 · Is it possible to format a cell based upon the format of another cell? For instance, if the cell to the left of a target cell is bold, is there a conditional formatting cell that can be used …
Conditional Formatting with Formula using Relative References
Jul 18, 2016 · Have you tried using conditional formatting as below? I simplified the formula in the example but should work for your case as well. It seems to me more practical for large ranges …
Conditional format if value within a % of another cell value
Feb 19, 2021 · Hi, thank you for the reply, do I apply these in the conditional formatting rules using a formula to determine which cells to format?
excel - Colour a cell based on another cell being blank AND …
Feb 1, 2023 · I have a question concerning conditional formatting in excel: I want to highlight one cell (lets say F1) in red but only if F6 it self is empty/blank and B1 is filled (it doesn't matter …
Excel: Can I create a Conditional Formula based on the Color of a …
28 I'm a beginner and trying to create a formula that modifies the contents of Cell A1 based on the color of the cell in B2; If Cell B2 = [the color red] then display FQS. If Cell B2 = [the color …
Excel Conditional Formatting Based on Another Cell [SOLVED]
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 …