Hello,
Which formula do I need so that the whole row turns yellow or green when there is a check mark next to “ordered” or “arrived”, or remains red when there is no check mark.
(2 votes)
Loading...Hello, I want to draw lines on a cylinder in Blender like the one in the picture. Does anyone know how to do this? Regards
Hello, I would like to know if it's possible to create a [Name1].bat file that runs invisibly in the background and ensures that another [Name2].bat file is open and can only be closed by the file itself using the exit command. Otherwise, if the user tries to close [Name2].bat, it will immediately reopen. Furthermore, as…
I honestly don't know what to say. Thanks for any answers!
I wrote two (completely neutral) comments on a video and they were immediately deleted as if I had NEVER written them… What's the point of this?? (I think it's an AI error somehow)
I would like to add a comment function to my website, but I find it difficult to find a provider that meets my requirements. I'm looking for a provider that's free, allows anonymous commenting without providing email addresses or other personal information, and can be easily integrated into my website by simply copying and pasting…
Hello, the question is already above. Greetings
The magic word is called “conditional formatting”. Here you can set everything possible that happens exactly what you imagine. Explaining it would take longer… can check in Excel in the help.
Good success 😉
I’ve been looking and I’ve already tried, but I can’t go ahead.
Try once a If-Dann function
I once entered the formula as it seems useful for me, but nothing works. (picture on question)
Hello,
the following illustration for the procedure is limited to the essential in the illustration.
You mark the cells (which are to be highlighted in color, in my play A9 to S9) where the data begins (have assumed A9).
Then on “Start“conditional formatting” as in Figure 4 create rules. The 1st rule is required because Intermediate lines are without data and for the lower rows without data, otherwise everything would be red if no hooks were set.
Keep accurate to the formulas of the respective conditional formatting and text formatting for columns Q and S (starting at line 9).
Greetings