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 1985 Registration date Monday August 16, 2010 Status Contributor Last seen May 24, 2023 - Mar 10, 2014 at 06:28 AM
Mazzaropi Posts 1985 Registration date Monday August 16, 2010 Status Contributor Last seen May 24, 2023 - Mar 10, 2014 at 06:28 AM
Related:
- Conditional formatting
- How to clear formatting in excel - Guide
- Excel conditional formatting if another cell contains specific text - Excel Forum
- Excel formula to change cell color without conditional formatting - Excel Forum
- To change conditional formatting that applies a red fill color to one that applies a green fill color, which of the following can you do? - Excel Forum
- Phone formatting software for pc - Download - File management
8 responses
Mazzaropi
Posts
1985
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
May 24, 2023
147
Mar 8, 2014 at 11:14 AM
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
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
taghreed almuhajiri
Posts
13
Registration date
Saturday March 8, 2014
Status
Member
Last seen
March 19, 2014
Mar 9, 2014 at 01:22 AM
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
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
Mazzaropi
Posts
1985
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
May 24, 2023
147
Mar 9, 2014 at 08:49 AM
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
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
taghreed almuhajiri
Posts
13
Registration date
Saturday March 8, 2014
Status
Member
Last seen
March 19, 2014
Mar 9, 2014 at 09:29 AM
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
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
Mazzaropi
Posts
1985
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
May 24, 2023
147
Mar 9, 2014 at 01:52 PM
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
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
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
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
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
Mazzaropi
Posts
1985
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
May 24, 2023
147
Mar 10, 2014 at 05:57 AM
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.
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.
taghreed almuhajiri
Posts
13
Registration date
Saturday March 8, 2014
Status
Member
Last seen
March 19, 2014
Mar 10, 2014 at 06:11 AM
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
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
Mazzaropi
Posts
1985
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
May 24, 2023
147
Mar 10, 2014 at 06:28 AM
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
If you have any other question, please, feel free to ask.
Have a nice day.
--
Belo Horizonte, Brasil.
Marcílio Lobão
