Conditional formatting

[Solved/Closed]
Report
Posts
13
Registration date
Saturday March 8, 2014
Status
Member
Last seen
March 19, 2014
-
Posts
1942
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
September 2, 2021
-
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

Posts
1942
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
September 2, 2021
145
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
Posts
13
Registration date
Saturday March 8, 2014
Status
Member
Last seen
March 19, 2014

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
Posts
1942
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
September 2, 2021
145
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
Posts
13
Registration date
Saturday March 8, 2014
Status
Member
Last seen
March 19, 2014

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
Posts
1942
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
September 2, 2021
145
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
Posts
13
Registration date
Saturday March 8, 2014
Status
Member
Last seen
March 19, 2014

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
Posts
1942
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
September 2, 2021
145
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.
Posts
13
Registration date
Saturday March 8, 2014
Status
Member
Last seen
March 19, 2014

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
Posts
1942
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
September 2, 2021
145
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