excel - Cell reference in conditional formatting -


my apologies if text in document in german, i'll try explain possible.

basically, sheet contains dates , times employee working. weekdays automatically generated, e.g. when month set october 2013, weekdays automatically update. ("di" -> "tu"/tuesday, "mi" -> "we"/wednesday, ...) default of excel document. everything's fine

this works out alright, don't have problems that. actual goal is, wanted make little bit better readable adding thicker lines after every sunday, signalizing end of week.

weeks seperated thick line

using conditional formatting, i've managed every line. e.g. line 14, used formula =mod(value($b$14);7)=1 determine, if value in column b , line 14 in fact sunday. if modulus of weekday divided 7 1, sunday , formatting style applied cells.

now, formula makes little hard work with. i'd have copy-paste lines each time , change line number each line. thought possible make more dynamic leaving out $-symbol (=mod(value($b1);7)=1), reason didn't work me.

what have type in inside value reference b-column in same line?

okay, issue applying condition on range on wrong active cell.

an active cell cell less blue in selected region; instance, in picture below, active cell a1:

1

and if active cell, able use formula:

=mod(value($b1);7)=1

there's simpler formula though:

=weekday($b1)=1

this means if active cell a32 or h32 in picture, formula wouldn't have worked, because condition formatting being applied wrong cell!


Comments

Post a Comment

Popular posts from this blog

java.util.scanner - How to read and add only numbers to array from a text file -

i'm learning java , have question regarding reading file want read numbers file contains strings well. here example of file: 66.56 "3 java 3-43 5-42 2.1 1 and here coding: public class test { public static void main (string [] args){ if (0 < args.length) { file x = new file(args[0]); try{ scanner in = new scanner( new fileinputstream(x)); arraylist<double> test = new arraylist<>(); while(in.hasnext()){ if(in.hasnextdouble()){ double f=in.nextdouble(); test.add(f);} else {in.next();} } catch(ioexception e) { system.err.println("exception during reading: " + e); } } my problem add 66.56,2.1 , 1 doesn't add 3 after "3 or ignores 3-43 , 5-42 can tell me how skip strings , add doubles here? thanks all said 3 ie; "3, 3-43 , 4-42 strings either u read string , split , check number @ " , - or put in space between characters , integers. jvm after compilation tre...
Read more

rewrite - Trouble with Wordpress multiple custom querystrings -

i'm working on adding multiple querystring , doesn't seem work. i've found codes seems work others might i'm missing something. i want like: http://mydomain.com/board/?getyear=2013&getsometext2=sometext to http://mydomain.com/board/2013/sometext/ i added code below functions.php file. doesn't seem work should though. this works. echoing querystring gets both variable without problem. http://mydomain.com/board/2013/sometext/ but doesn't. tested querystring vis isset() seems nothing being set/get http://mydomain.com/board/2013/ function add_query_vars($vars) { $vars[] = "getyear"; $vars[] = "getsometext2"; return $vars; } add_filter('query_vars', 'add_query_vars'); function add_rewrite_rules($arules) { $anewrules = array('board/([^/]+)/([^/]+)/?$' => 'index.php?pagename=board&getyear=$matches[1]&getsometext2=$matches[2]'); $arules = $a...
Read more