Forum Discussion

Copper Contributor

Nov 07, 2024

Solved

Overwriting the conditional format of a cell

Hi. In my spreadsheet I have already set up a conditional format to turn a cell red if "Labour" has been entered in to C2, this turns L2 in the sales percentage column to red. What I'd like t...

Excel for web

Riny_van_Eekelen
Nov 07, 2024
You need two rules for that as shown in the picture below.
in the on-line version it looks like this:

Riny_van_Eekelen

Platinum Contributor

Nov 07, 2024

Get rid of the one you have. Just the two rules as indicated in the pictures. Note that you should not reference C2:C76.

Hotfuzz38
Copper Contributor
Nov 07, 2024
Ok. I'll try this. If I don't reference C2:C76 then will that not mean that the rule won't apply if "Labour" is written in any cell in column C? I need the same rule to apply to all cells in column C of the table.

Thanks again
- Riny_van_Eekelen
  Platinum Contributor
  Nov 07, 2024
  Don't worry. Select L2:L76 and apply the formulas. On L2 they will 'look at' C2, in L3 at C3 and so on.
  - Hotfuzz38
    Copper Contributor
    Nov 07, 2024
    Could I use the same formula to highlight a cell if it's been missed? So in G2 I have a quantity and in H2 I have the length of it. These both need to have a number in them for a different formula to work. How could I adapt your formula so it will highlight H2 as red if it has been left blank and highlight it green when a number has been put in?