Conditional formatting

Solved/Closed
taghreed almuhajiri Posts 13 Registration date Saturday March 8, 2014 Status Member Last seen March 19, 2014 - Mar 8, 2014 at 09:03 AM
Mazzaropi Posts 1980 Registration date Monday August 16, 2010 Status Contributor Last seen December 22, 2022 - Mar 10, 2014 at 06:28 AM
hello

I did a table in Excel ( its a vacation tracker)
I'll give you an example for what i'm trying to do

Ex : my vacation starts from 15-mar to 20-mar
i already created a whole year cells but I want these cells to be highlighted once i determinate the date

did you get the idea ..!?

8 replies

Mazzaropi Posts 1980 Registration date Monday August 16, 2010 Status Contributor Last seen December 22, 2022 146
Mar 8, 2014 at 11:14 AM
taghreed almuhajiri, Good morning.

Scenario:
D2:ND2 --> Days (01/01/2014......12/31/2014)
A2 --> Date start vacation
B2 --> Date end vacation

Try to do:
--> Select D2:ND2
--> Menu Conditional format
--> New Rule --> Using formula

Formula --> =AND(D2>=$A$2,D2<=$B$2)
Use a format colour that you prefer.
OK

Please, tell us if it worked for you.
I hope it helps.
--
Belo Horizonte, Brasil.
Marcílio Lobão
0
taghreed almuhajiri Posts 13 Registration date Saturday March 8, 2014 Status Member Last seen March 19, 2014
Mar 9, 2014 at 01:22 AM
Good morning sir,

thank you so much for replaying
i did exactly like you said but the whole cells was highlighted
idk if it's possible to send you the file i made so you can see what i want to do
or even a print scrn of it

thank you again
appreciated
0
Mazzaropi Posts 1980 Registration date Monday August 16, 2010 Status Contributor Last seen December 22, 2022 146
Mar 9, 2014 at 08:49 AM
taghreed almuhajiri, Good morning.

Are you sure that the scenario is the same?

Ok.
Save your Excel file at www.speedyshare.com (it's a free site and non register necessary) and put a link to download here.

I using here Excel 2007
0
taghreed almuhajiri Posts 13 Registration date Saturday March 8, 2014 Status Member Last seen March 19, 2014
Mar 9, 2014 at 09:29 AM
yes i'm sure

when you see the file sir you will get the idea exactly ,

what i want here is ( After i type the start & the end date) it will show automatically in the months part
i did highlight cells from X3 to AB3 manually just to show you
same idea but automatically instead of manually

is't even possible for Excel ?

http://speedy.sh/t5yCD/Test.xlsx
0
Mazzaropi Posts 1980 Registration date Monday August 16, 2010 Status Contributor Last seen December 22, 2022 146
Mar 9, 2014 at 01:52 PM
taghreed almuhajiri, Good afternoon.

I downloaded your Excel file.

I did a little modification on your file, to make possible a conditional format to work on.
I changed your single numbers to dates. Line 2.

Then I used a Conditional Formatting with a formula
=AND(N$2>=$E3;N$2<=$F3) to $N$3:$NN$22

Make your own tests.
http://speedy.sh/UfAaV/09-03-2014-en-Kioskea-Test.xlsx

Please, is it what you want?
I hope it helps.

Have a nice day.
--
Belo Horizonte, Brasil.
Marcílio Lobão
0

Didn't find the answer you are looking for?

Ask a question
taghreed almuhajiri Posts 13 Registration date Saturday March 8, 2014 Status Member Last seen March 19, 2014
Mar 10, 2014 at 02:13 AM
Good morning sir,

I can't download the file, it shows me its blocked

could you please upload it on http://www.megafileupload.com/

i appreciate your help
thank you
0
Mazzaropi Posts 1980 Registration date Monday August 16, 2010 Status Contributor Last seen December 22, 2022 146
Mar 10, 2014 at 05:57 AM
taghreed almuhajiri, Good morning.
I testesd the file from my link and it's ok.

As you requested:
http://www.megafileupload.com/en/file/506995/09-03-2014-en-Kioskea-Test-xlsx.html

Please, tell us if it worked for you.
I hope it helps.
0
taghreed almuhajiri Posts 13 Registration date Saturday March 8, 2014 Status Member Last seen March 19, 2014
Mar 10, 2014 at 06:11 AM
hello sir,

the website is fine its just blocked from my country

anyway, what you did is exactly what am looking for
i can't thank you enough

i wish you a very joyful life
0
Mazzaropi Posts 1980 Registration date Monday August 16, 2010 Status Contributor Last seen December 22, 2022 146
Mar 10, 2014 at 06:28 AM
I feel glad that I helped you.
If you have any other question, please, feel free to ask.

Have a nice day.
--
Belo Horizonte, Brasil.
Marcílio Lobão
0