New answers tagged conditional-formatting
I'm not SO sure and I face the same problem frequently. I'd say that the 'Apply to' field in the Conditional Formatting (CF) panel will ALWAYS work dynamically. So, it will ALWAYS convert any references to the format =$A$1:$A$50. It's a pain.
Try this: =CONCATENATE("REQ-",TEXT(A3,"000")) Formating the value to 000 and making it text.
German OS is probably the issue. Looks like the period is used as the thousand separator on your system. Try changing the options, either in the system or just in Excel, to use the point for decimal separator while you do this operation.
You can do this using condition format based on formula. Select A to L columns, add a new conditional formatting rule (Conditional formatting > New rule... > Use a formula to determine which cells to format) and enter the following formula: =AND(OR($G1="In progress";$G1="With 3rd Party";$G1="Identifying");OR(ISBLANK($H1);ISBLANK($J1);ISBLANK($K1)))
Top 50 recent answers are included