Excel – Ganze Zeile bedingt formatieren

Heute wurde ich in einer Schulung gefragt, wie man eine ganze Zeile aufgrund einer Bedingung in einer einzelnen Zelle formatieren kann.

Die Lösung ist eine bedingte Formatierung basierend auf einer Formel:

Bedingte Formatierung

Die Formel lautet etwa im oben angeführten Beispiel =$B2="Samstag" – wobei hier wichtig ist, dass man die Spalte (in dem Fall B) mit dem $-Symbol (oder F4-Taste) fixiert. Anwenden muss man die bedingte Formatierung natürlich dann auf den ganzen Bereich der formatiert werden soll.

Im obigen  Beispiel habe ich übrigens Samstag unterschiedlich formatiert als Sonntag. Möchte ich beide gleich formatieren, aber nur eine Regel verwenden, kann ich die “Oder” Funktion verwenden.

Das würde dann so aussehen:
Bedingte Formatierung Wochenende

Formel: =ODER($B2="Samstag";$B2="Sonntag")

Kommentare (43) -

Thomas
Thomas
15.04.2011 18:28:26 #

Ich habe das für meine Tabelle auch übernommen, nur passiert irgendwie nix.
Wenn in einer Zelle in Spalte P ein X steht, soll die jeweils dazugehörige Zeile in grauer Schrift erscheinen.
Ich gehe dann wie folgt vor:
Anklicken einer Zelle in Spalte P, dann auf Bedingte Formate, neue Regel erstellen, Formel zur Ermittlung ...
Werte formatieren, für die diese Formel wahr ist: ="X" dann auf OK
Nun klicke ich in das Eingabefeld und ziehe einen Rahmen um die Zellen, die dann formatiert werden sollen, dazu auch die der Spalte P.
Die Formel sieht dann so aus: =$A$2EmbarassedP$2637

Wenn ich dann nun das X eingebe und auf Enter drücke, passiert, wie bereits gesagt, nichts.

Wo ist mein Fehler?
Wäre toll wenn ich dafür eine Lösung bekäme.

Grüßle aus der Weiß-Blauen Stadt: München

Sven Froese
Sven Froese
20.04.2011 12:39:08 #

Hi Thomas,

Du musst vorher Deine gesamte Tabelle markieren, in der Du formatieren willst, nicht nur "anklicken einer Zelle".

MfG Sven

Extreme CBT
Extreme CBT
02.08.2011 00:06:31 #

Great web page! I'm loving it! I'll appear back again for sure!!

500 rubles
500 rubles
16.12.2011 18:46:16 #

- yo , Thank you a lot for generating this internet site . I m into gambling niche and have discovered this website utilizing search on google . Is going to be confident to share . I am  affiliate and have discovered your website quite informational Numerous thanks , see ya. :S

phlebotomy technician salary
phlebotomy technician salary
03.06.2012 21:31:07 #

Great paintings! This is the type of info that should be shared across the internet. Disgrace on the seek engines for now not positioning this put up higher! Come on over and seek advice from my web site . Thank you =)

The Walking Dead Season 3
The Walking Dead Season 3
04.06.2012 23:15:44 #

you are truly a good webmaster. The web site loading speed is amazing. It kind of feels that you're doing any unique trick. Moreover, The contents are masterpiece. you've performed a wonderful activity on this matter!

crossfit utah
crossfit utah
04.06.2012 23:49:26 #

Great blog right here! Additionally your web site lots up fast! What host are you the usage of? Can I am getting your affiliate link to your host? I desire my web site loaded up as fast as yours lol

metabolism myths
metabolism myths
04.06.2012 23:50:09 #

Wonderful web site. A lot of helpful information here. I am sending it to some pals ans also sharing in delicious. And obviously, thank you on your sweat!

carpet cleaning boise, idaho
carpet cleaning boise, idaho
05.06.2012 20:14:02 #

I've been absent for a while, but now I remember why I used to love this blog. Thanks , I¡¦ll try and check back more frequently. How frequently you update your site?

DFB Trikot 2012 grün
DFB Trikot 2012 grün
05.06.2012 20:14:47 #

A person necessarily help to make seriously articles I would state. This is the very first time I frequented your web page and to this point? I amazed with the analysis you made to create this actual publish incredible. Great process!

free sample
free sample
05.06.2012 20:49:55 #

You could definitely see your skills within the work you write. The sector hopes for even more passionate writers such as you who are not afraid to say how they believe. Always go after your heart.

social media campaign
social media campaign
06.06.2012 23:59:36 #

Nice weblog right here! Additionally your website rather a lot up very fast! What host are you using? Can I get your associate link for your host? I desire my web site loaded up as fast as yours lol

schaumburg chiropractor
schaumburg chiropractor
07.06.2012 21:15:09 #

I definitely wanted to make a small note to be able to say thanks to you for some of the marvelous suggestions you are placing on this website. My particularly long internet research has at the end of the day been recognized with sensible ideas to share with my partners. I would claim that most of us visitors are unequivocally fortunate to be in a remarkable website with so many outstanding professionals with very beneficial things. I feel very much lucky to have come across your site and look forward to some more awesome minutes reading here. Thank you again for all the details.

puerto rico zip code
puerto rico zip code
08.06.2012 18:27:26 #

I think other web-site proprietors should take this site as an model, very clean and fantastic user genial style and design, let alone the content. You are an expert in this topic!

kids activities in melbourne
kids activities in melbourne
10.06.2012 21:32:33 #

I've been surfing online greater than 3 hours as of late, yet I by no means discovered any attention-grabbing article like yours. It is pretty value enough for me. In my view, if all webmasters and bloggers made good content as you probably did, the internet will be much more helpful than ever before.

kids activities in Brisbane
kids activities in Brisbane
10.06.2012 22:16:27 #

There is perceptibly a bundle to identify about this.  I think you made certain nice points in features also.

healthy thyroid gland
healthy thyroid gland
10.06.2012 22:50:11 #

My wife and i were absolutely fulfilled that Edward could conclude his survey by way of the precious recommendations he got using your web pages. It's not at all simplistic just to continually be giving freely guides which usually a number of people might have been making money from. Therefore we see we need the website owner to be grateful to because of that. All of the illustrations you made, the simple blog menu, the friendships you make it easier to promote - it is mostly fabulous, and it's aiding our son and our family believe that the idea is thrilling, and that's seriously serious. Thank you for the whole lot!

buy sexy lingerie uk
buy sexy lingerie uk
10.06.2012 22:52:34 #

Fantastic goods from you, man. I've understand your stuff previous to and you are just too great. I really like what you have acquired here, really like what you're saying and the way in which you say it. You make it entertaining and you still take care of to keep it smart. I cant wait to read much more from you. This is really a terrific web site.

I wanted to post you this very little word so as to thank you very much over again over the great methods you have shared in this case. This has been certainly remarkably generous of you to grant openly exactly what many individuals could possibly have sold for an e book in making some money for their own end, specifically considering the fact that you could possibly have done it in case you considered necessary. Those concepts likewise worked to provide a fantastic way to understand that the rest have similar zeal really like my very own to know the truth much more on the topic of this condition. I know there are a lot more pleasurable sessions ahead for people who take a look at your blog.

vender por internet
vender por internet
10.06.2012 22:59:58 #

I have learn some good stuff here. Definitely worth bookmarking for revisiting. I surprise how a lot attempt you set to create the sort of wonderful informative web site.

body by vi challenge
body by vi challenge
10.06.2012 23:54:03 #

Hi, Neat post. There's a problem together with your website in internet explorer, might check this¡K IE still is the market leader and a good component to other people will miss your magnificent writing because of this problem.

l-lysine benefits
l-lysine benefits
11.06.2012 17:20:36 #

A person necessarily help to make severely posts I'd state. This is the very first time I frequented your website page and to this point? I surprised with the research you made to make this actual submit incredible. Magnificent process!

Salem Marketing
Salem Marketing
11.06.2012 17:23:03 #

Magnificent site. Lots of useful info here. I am sending it to some buddies ans also sharing in delicious. And obviously, thank you in your sweat!

Salem Oregon web design
Salem Oregon web design
11.06.2012 17:25:36 #

Thanks , I've just been searching for information about this topic for ages and yours is the best I have came upon so far. However, what concerning the bottom line? Are you positive about the source?

lecithin side effects
lecithin side effects
11.06.2012 17:58:09 #

Hello my family member! I want to say that this post is awesome, great written and include almost all vital infos. I would like to peer extra posts like this .

clothing
clothing
11.06.2012 18:05:10 #

My husband and i felt now cheerful  Edward managed to do his homework while using the ideas he grabbed while using the web site. It's not at all simplistic to simply choose to be giving out tips and hints that many many others could have been trying to sell. We really already know we now have the writer to be grateful to because of that. Those explanations you have made, the straightforward web site menu, the relationships you assist to create - it's many extraordinary, and it is facilitating our son in addition to the family reason why the content is thrilling, and that is unbelievably pressing. Thanks for the whole lot!

bilberry benefits
bilberry benefits
11.06.2012 18:05:30 #

Thank you a lot for giving everyone remarkably special chance to read from here. It is always very sweet and full of amusement for me personally and my office friends to search your web site at minimum 3 times weekly to see the newest secrets you have. Not to mention, I am just actually contented concerning the magnificent techniques you serve. Certain 3 facts on this page are clearly the most beneficial I have had.

d-mannose side effects
d-mannose side effects
11.06.2012 18:45:14 #

I must express my appreciation to you for bailing me out of this particular trouble. As a result of surfing throughout the search engines and finding ideas which are not powerful, I believed my entire life was over. Existing without the answers to the difficulties you've resolved by way of your good article is a serious case, and the kind which may have negatively damaged my entire career if I had not discovered your site. That knowledge and kindness in dealing with every part was crucial. I don't know what I would have done if I had not come across such a point like this. I can also at this moment look ahead to my future. Thank you very much for this high quality and result oriented help. I will not think twice to recommend your blog to anybody who needs assistance on this subject matter.

colorado springs lodging
colorado springs lodging
11.06.2012 18:54:59 #

hey there and thank you for your information – I have definitely picked up something new from right here. I did however expertise a few technical points using this site, as I experienced to reload the website many times previous to I could get it to load properly. I had been wondering if your web host is OK? Not that I'm complaining, but slow loading instances times will very frequently affect your placement in google and can damage your high quality score if ads and marketing with Adwords. Well I’m adding this RSS to my email and can look out for much more of your respective fascinating content. Ensure that you update this again very soon..

l-tyrosine side effects
l-tyrosine side effects
11.06.2012 19:39:23 #

Hi there, I discovered your blog by means of Google even as searching for a related subject, your site came up, it seems to be good. I have bookmarked it in my google bookmarks.

ginkgo biloba side effects
ginkgo biloba side effects
11.06.2012 19:39:24 #

My husband and i got  thankful when Jordan could round up his inquiry through the entire precious recommendations he grabbed in your site. It's not at all simplistic to simply happen to be giving freely guides  people may have been trying to sell. And we fully grasp we now have the blog owner to give thanks to for that. The main explanations you've made, the straightforward website navigation, the friendships you can give support to create - it's got most exceptional, and it is letting our son and the family consider that that matter is pleasurable, which is certainly wonderfully mandatory. Thank you for the whole thing!

Financing
Financing
12.06.2012 22:37:36 #

Thank you for the sensible critique. Me & my neighbor were just preparing to do some research on this. We got a grab a book from our area library but I think I learned more from this post. I'm very glad to see such fantastic info being shared freely out there.

computer security
computer security
12.06.2012 23:23:12 #

What i do not understood is in reality how you're not really much more smartly-liked than you may be now. You're so intelligent. You recognize thus significantly in the case of this subject, made me for my part consider it from numerous varied angles. Its like women and men aren't involved unless it is one thing to accomplish with Woman gaga! Your personal stuffs outstanding. Always maintain it up!

snabba pengar
snabba pengar
12.06.2012 23:25:07 #

I have read several good stuff here. Definitely price bookmarking for revisiting. I surprise how much effort you set to make one of these magnificent informative website.

ferievejret
ferievejret
13.06.2012 21:54:07 #

Great write-up, I¡¦m normal visitor of one¡¦s site, maintain up the nice operate, and It is going to be a regular visitor for a lengthy time.

painter columbia sc
painter columbia sc
13.06.2012 22:24:33 #

hello there and thank you for your information – I’ve certainly picked up something new from right here. I did however expertise some technical issues using this site, since I experienced to reload the web site many times previous to I could get it to load properly. I had been wondering if your web hosting is OK? Not that I'm complaining, but slow loading instances times will often affect your placement in google and can damage your high-quality score if ads and marketing with Adwords. Anyway I’m adding this RSS to my e-mail and could look out for a lot more of your respective exciting content. Make sure you update this again soon..

mytravelsafety.net
mytravelsafety.net
13.06.2012 22:28:02 #

Hey very nice blog!! Man .. Beautiful .. Wonderful .. I'll bookmark your site and take the feeds additionally¡KI am happy to find a lot of useful information right here within the publish, we want develop extra strategies in this regard, thank you for sharing. . . . . .

Full Movie Bonus
Full Movie Bonus
14.06.2012 21:25:09 #

I savor, result in I discovered just what I used to be taking a look for. You've ended my four day lengthy hunt! God Bless you man. Have a great day. Bye

asthma attack
asthma attack
14.06.2012 21:26:01 #

Thanks , I have recently been looking for information approximately this topic for a while and yours is the greatest I've came upon till now. However, what about the conclusion? Are you sure about the supply?

billige Handys
billige Handys
15.06.2012 17:42:13 #

I carry on listening to the news broadcast lecture about getting boundless online grant applications so I have been looking around for the top site to get one. Could you tell me please, where could i get some?

dont be broke
dont be broke
15.06.2012 17:45:51 #

Of course, what a splendid website and educative posts, I will bookmark your website.Best Regards!

compare digital camera
compare digital camera
15.06.2012 18:49:52 #

Hello there, I found your site by way of Google at the same time as looking for a comparable matter, your website got here up, it looks good. I have bookmarked it in my google bookmarks.

Buy Leads
Buy Leads
15.06.2012 19:21:52 #

I must express my appreciation to you for rescuing me from this type of situation. After scouting through the online world and obtaining ideas which are not beneficial, I figured my entire life was done. Existing minus the approaches to the issues you have fixed as a result of your short article is a serious case, and the kind which could have negatively affected my entire career if I had not discovered your web blog. That capability and kindness in maneuvering the whole lot was helpful. I'm not sure what I would've done if I had not discovered such a solution like this. I can at this point look forward to my future. Thanks for your time very much for this specialized and results-oriented guide. I will not hesitate to recommend your web site to anyone who should get assistance on this subject matter.

Kommentar schreiben

  Country flag

biuquote
  • Kommentar
  • Live Vorschau
Loading

Facebook

Letzte Tweets

Twitter Mai 26, 23:39
Gelbe Engel! Danke!

Twitter Mai 18, 21:34
Finland was terrible. #Eurovision

Twitter Mai 17, 12:49
just blogged Ist das Surface Pro teuer? – Ein Fact-Check: Gestern wurde angekündigt, dass das Surface Pro in D... http://t.co/PhW7qzhkUq

Folge mir auf Twitter!

Über den Autor

MCTS

Christian Haberl Christian Haberl ist seit mehr als 10 Jahren als EDV Berater, Vortragender und Trainer tätig. Er kann sich nicht für ein Spezialgebiet entscheiden, drum heißt dieser Blog auch "Kraut & Rüben Blog" - Unter seine Interessen fallen Web-Entwicklung auf ASP.NET Basis, Information Worker & Productivity Technologien (Windows, Office), Server (Windows Server, Small Business, Virtualisierung, Exchange), Scripting, Spam Filtering/Security und Digital Home. Christian Haberl ist auch einer der führenden Produktspezialisten für Windows Media Center und Windows Home Server und ist Direktor des ClubDigitalHome.
Im Jahr 2008 hat Christian Haberl über 200 Vorträge und Schulungen durchgeführt.
Im Frühjahr 2009 wurde Christian Haberl von Microsoft Österreich zum "Influencer" ernannt, weiters wurde er Microsoft Certified Technology Specialist / Microsoft Certified Connected Home Integrator sowie Microsoft Certified Consumer Sales Specialist.

Month List

Netzwerk Management

Bandwidth

RecentComments

Comment RSS