Forum Discussion
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...
You need two rules for that as shown in the picture below.
in the on-line version it looks like this:
You need two rules for that as shown in the picture below.
in the on-line version it looks like this:
Do I overwrite my =C2:C76="Labour" with =AND(C2:C76="Labour",L2<>0)?
Or do I need to keep that and have three rules?
Thanks
