top of page

You are learning Conditional Formatting in MS Excel

How can I highlight cells based on cell formatting (e.g., font color)?

Unfortunately, Excel doesn't have a built-in way to directly highlight cells based solely on their formatting (font color, cell fill, etc.). However, you can achieve a similar effect using Conditional Formatting with a clever formula.

Here's how:

1. Select the cells you want to format: Choose the range of cells where you want to identify specific font colors for highlighting.

2. Go to Conditional Formatting: Navigate to the "Home" tab on the Excel ribbon. In the "Styles" group, click the dropdown arrow next to "Conditional Formatting" and choose "New Rule."

3. Use a formula to determine which cells to format: In the "New Formatting Rule" window, select "Use a formula to determine which cells to format" under "Select a Rule Type."

4. Formula for highlighting based on font color: Here's the key formula:

```excel
=GET.CELL.COLOR(A1) = RGB(desired_red, desired_green, desired_blue)
```

- Replace `A1` with the cell reference where you want to check the font color. Adjust the cell reference based on your actual data range.
- Replace `desired_red`, `desired_green`, and `desired_blue` with the specific red, green, and blue values of the font color you want to highlight. You can find these color codes online or use the "Fill Color" option within the formatting menu to pick a color and see its corresponding RGB code.

5. Set the formatting for highlighted cells: Click the "Format" button next to the formula box. Choose the desired formatting options like fill color or font style for the highlighted cells.

6. Click OK: Click "OK" on both the "Format Cells" and "New Formatting Rule" windows.

Now, any cell within your selected range that has the specific font color defined in the formula will be highlighted with your chosen formatting.

Note: You can create multiple conditional formatting rules with different formulas to highlight cells based on various font colors.

bottom of page