I want to create an Excel spreadsheet that displays the following:
One column contains the age and then there are two more columns for badges level 1 and level 2. The cell of level 2 (column J) should be orange if the following conditions are met
which formula do I need
(1 votes)
Loading...Hello everyone, I have a laptop that, unfortunately, has recently started having problems with its Wi-Fi adapter again. Whenever the PC is turned on and not in use for a while, the Wi-Fi adapter deactivates itself—or rather, disappears. If you look in the device manager, it says it's "not connected" (Code 45), which is, of…
There's usually a solution for every problem online, but I can't find anything useful for this. I'd like to use EqualizerAPO, and for that, "signal enhancements" need to be enabled. Usually, a restart is sufficient after I specify it in the EqualizerAPO configurator. I'm prompted to restart my PC for the settings to take effect,…
Good evening everyone, I installed Windows 10 on my computer. I've always had administrator rights up until now. However, I made a mistake and downgraded myself to a guest account, and I no longer have any access to my PC. What can I do? And is that a problem, since I can't add users or…
I have a product key for the Home version and it doesn't work for the Pro version, so I wanted to ask how to change it because I can't figure out anything. Thanks
Hello everyone, In the analysis below, Excel made a mistake with the percentage values! 19 out of 51 points are 37, xyz%, not 27%! My charts are correct in other files! Can anyone help me?
I would like to insert a checkbox into an Excel sheet where, when the checkbox is set, a value in another cell minus 30 minutes is calculated. What is the best way to do this?! Thank you in advance.
Das ist wenn ich mich richtig erinnere nur mit VBA sinnvoll möglich, da bedingte Formatierungen sich entweder auf die Zelle selbst oder eine fixe Formel beziehen, die man dann für jede Zelle extra erstellen müsste.
Einfacher wäre es wenn man eine Statusspalte mit einer geschachtelten Wenn-Funktion erstellt, die dann meinetwegen je nach Bedingungen 0, 1 oder 2 als Ergebnis bekommt und davon abhängig kann man die Zelle bedingt formatieren.
No, that's fine. The "fixed formula" can also have a relative reference.
This is generally preferable, partly because the result can then be used further in the table.
Nesting means you don't need the If function for this use case.
Wouldn't it be much easier to simply put the result (if it's true) into the cell instead of a cell color?
For the alternative, you can simply use two "", then it will remain empty if the condition is not met.
example
=if(A2=7;"Bingo";"")
z.B. so
Bedingte Formatierung mit Formel.
=UND($D>=13;$I<>““)
I tried but somehow it doesn't work. I've added something above, maybe it will work then.
The answer from is almost correct.
When the conditional formatting area starts in row 2, this is the formula:
Once you have created the conditional formatting, you can open it again via "Conditional Formatting" > "Manage Rules…" and enter the range to which the conditional formatting should apply in the "Applies to" field.