i have been making a to do list, wat i want is to mark the day if its today. (sorry for my bad enlish, i am a dutch guy) so i can see where i have been.
i hope thats an easy formule, i put a sample with.
i have been making a to do list, wat i want is to mark the day if its today. (sorry for my bad enlish, i am a dutch guy) so i can see where i have been.
i hope thats an easy formule, i put a sample with.
Goedemiddag,
You can achieve this with conditional formatting.
In your example, select the whole range of dates, clicking and dragging from cell A1.
Then go to conditional formatting, new rule, use a formula to determine which cells to format, and enter
=A1=TODAY()
Select your required formatting, and away you go.
Rule 1: Never merge cells
Rule 2: See rule 1
"Tomorrow I'm going to be famous. All I need is a tennis racket and a hat".
i dont know what you mean, what i want to do is make a list of to do en so i can make a plans for the day of work. i am not so good with the formulas
Do you need to highlight the cell with today's date in it, or do you want to extract a thing to do from a specific date? Sorry for not understanding.
i want to highlight the date and the day in a color if its possible, for the things to do i have a list for the projects on the work, somethings have to be waiting and somethings i need it fast. but thats not relevant now.
So if you go through the actions described in my original reply the current date will be highlighted. I have attached an example here:dag markering (2).xlsx
thanx for so for, how can i this formular into my other project and gif it another color (because i print the weekly staus on a black&withe printer), and how can i mark the day next to the date.
Can I suggest you take a look at some conditional formatting tutorials? THere's a good one here: http://www.contextures.com/xlCondFormat03.html This will explain how it works much more clearly than I can.
sorry, i look up to the treadment but i cant see it how te do it, i have a dutch office2007. is there alsow an vba code from.
Ik denk dat je je vraag beter op helpmij.nl kunt stellen.
Hi,
See if this example helps.
One test is worth a thousand opinions.
Click the * Add Reputation below to say thanks.
but how is the formular,
i dont understant it how i get the formular into it
I used Conditional Formatting to get the date to show yellow. Read articles on Conditional Formatting like:
http://www.howtogeek.com/howto/45670...al-formatting/
i got it done, sorry for not understanding, i got a dutch excel, and the answers that i got here is all in the english excel. it is a lot of mis cummunication or not good understanding.
i want to thank everybody for thinking.
greets to everybody
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks