Video Tip: Conditional Formatting and Data Validation

funny wallpaper » Video Tip: Conditional Formatting and Data Validation

funny wallpaper » Video Tip: Conditional Formatting and Data Validation — Fri, 05 Sep 2008 23:57:02 GMT

PingBack from http://housesfunnywallpaper.cn/?p=4331

re: Video Tip: Conditional Formatting and Data Validation

hanan — Sat, 06 Sep 2008 07:51:22 GMT

At the conditional formatting formula,you can write only:

=b12=a13

re: Video Tip: Conditional Formatting and Data Validation

Eric — Sat, 06 Sep 2008 08:28:20 GMT

I don't mind videos, but, to me, the content of this one doesn't really fit the technical nature of the blog.

re: Video Tip: Conditional Formatting and Data Validation

David — Sat, 06 Sep 2008 15:54:52 GMT

Video seems to be the wave of the future on the Internet, but it involves a much bigger commitment from the reader/viewer. I can skim a text entry in a couple of seconds and move on, but I may have to watch 30 seconds or more of a video to determine if it's worthwhile to me. In fact, with video I might sit through a couple minutes and find I didn't learn anything, while I could have covered a couple dozen blog entries or more in the same time.

re: Video Tip: Conditional Formatting and Data Validation

Sofa_Inferno — Wed, 10 Sep 2008 18:13:20 GMT

Thanks for the Tip, nice effect and easy to manage! Maybe it is woth mentioning for foreign users that one has to adjust the formula(s) according to their language version of Excel (wonder who came up with that Idea, it really scews things up sometimes and English is so international!)

For us German users it is =wenn(B$2$..... instead of =if(B$2$....

I also like the way you presented the tip, although i can understand the concerns of David. A video-only presentation might be a bit too little but maybe with a text that contains the basic ideas behind the task (maybe like a to-do-list) it would help the more advanced Excelists not to waste their time.

I prefer videos so I can follow the instructions step by step and can see the onscreen output in realtime. In addition to the example file provided for download it worked just perfect for me.

re: Video Tip: Conditional Formatting and Data Validation

Dan — Wed, 10 Sep 2008 18:26:56 GMT

Keep it text and on topic for the blog. Not everyone in the world has high-speed internet and not every location allows streaming video. Agree with David that video is a MAJOR waste of time unless the content somehow requires a demonstration.

re: Video Tip: Conditional Formatting and Data Validation

Ron de Bruin — Sun, 14 Sep 2008 14:03:09 GMT

Hi Sam

Thanks for the tip and video<g>

This is working for every language version

=$B$2=$A$13

re: Video Tip: Conditional Formatting and Data Validation

SamRad — Tue, 23 Sep 2008 02:48:24 GMT

Thanks for the comments! Some replies:

Hanan

Thanks, no need for the if … I’m so used to doing it for otherthings its just embedded in my head now.

Eric

Thanks, we’ve posted other non-super technical stuff and it went over ok, maybe this tip isn’t really techy enough though.

David

Good points overall, videos can be more time consuming.

Sofa_inferno

Good points on the international text, I’ll have to watch out for that. At least it worked when you opened the file :-)

Dan

True on the high speed internet point, just trying something different here since I’ve seen folks happy with other video blogs and video sites in general. If I ever do another video blog, I’ll be sure to include a full text write up with it.

Ron

Thanks for the formula, realize now it should have been that way :-)