Excel Conditional Formatting Based On Another Cell Color

You can do as follows to shade a cell based on another cell value in Excel. It may be easier to use HEX2DEC to specify colors. In this example we have a table in cells Q1 to S10 that display the fill colors that we want to apply for each rock type. Use the Highlight Cell Rules to highlight cells by comparing the cells value to another value.

Excel Formula Conditional Formatting Based On Another Cell Exceljet

Its a very easy process to set up a formatting formula.

Excel conditional formatting based on another cell color. Highlight the top or bottom in a range of values. Online Tutorials Office Tab. In the code A1 is the cell contains the fill color you will match to C1.

If double click on cell with left mouse button then red. Conditional formatting based on the color of another cell. IdentifyColor CellToTestInteriorColor End Function.

The Edit the Rule Description section at the bottom of the window is where youll spend a bit. 21 Select Use a formula to determine which cells to format option in the Select a Rule Type box. Use Conditional formatting to Highlight Duplicates in a range of Cells.

I tried formatting the cell with the name to include all of the cells in the row from EO. Please change them based on your needs. Excel does not provide conditional formatting rules based on the color of cells.

Conditional Formatting Based On Another Cell Learn How To Apply