Excel - IF Function Problem - Expert Solution

Question description:
This user has given permission to use the problem statement for this blog.

Hi I want to format cells if they are lesser/lower than a specified date. It would be a great help if I get a solution as soon as possible
Solved by K. B. in 23 mins
This is the chat thread from the real Excelchat help session. It contains no private user information.
Excelchat Expert 18/12/2017 - 07:00
Welcome, Thanks for choosing Got-It Pro Excel. How may I help you today?
Excelchat Expert 18/12/2017 - 07:02
Based from your description, I will now be creating an example at the beside table.
Excelchat Expert 18/12/2017 - 07:05
May I know if what kind of format do you prefer for the dates?
Excelchat Expert 18/12/2017 - 07:05
Do you want the format to be highlighting the lower dates?
Excelchat Expert 18/12/2017 - 07:08
Hello, as you can see in the table, I've done a simple formatting.
Excelchat Expert 18/12/2017 - 07:08
Or simple conditional format rather.
Excelchat Expert 18/12/2017 - 07:09
Let's say our target date is December 15, 2017 which is 12/15/2017
Excelchat Expert 18/12/2017 - 07:10
Correction, I've used December 10, 2017 in the example as target date.
Excelchat Expert 18/12/2017 - 07:11
And as you can see the following dates that are earlier than Dec. 10 is highlighted as Red.
Excelchat Expert 18/12/2017 - 07:12
This means that the format is recognizing dates that are lower or earlier than Dec. 10.
Excelchat Expert 18/12/2017 - 07:12
Okay, so how to do the formatting?
Excelchat Expert 18/12/2017 - 07:13
First, I select all the cells that will be included in the formatting which is for example, A1 to A6.
Excelchat Expert 18/12/2017 - 07:14
After selecting, I now click the "HOME" button at the selection bar above the excel sheet.
Excelchat Expert 18/12/2017 - 07:15
After clicking "HOME", you will see in the middle part of the ribbon the button "Conditional Formatting." You should click that drop-down button.
Excelchat Expert 18/12/2017 - 07:16
Once clicked, you will see another selection of formats. I just used the first one which is "Highlight Cell Rules."
Excelchat Expert 18/12/2017 - 07:16
After hovering or tapping that selection, you will now select "Less Than" option.
Excelchat Expert 18/12/2017 - 07:16
Which is in line with your problem description.
Excelchat Expert 18/12/2017 - 07:17
After clicking or tapping the "Less Than" option, a small window will appear.
Excelchat Expert 18/12/2017 - 07:18
You will now enter the desired target date that will be the basis of the lower or earlier dates to be marked as you wish.
Excelchat Expert 18/12/2017 - 07:19
For example, I've entered 12/10/2017 with a highlight of "Light Red Fill with Dark Red Text."
Excelchat Expert 18/12/2017 - 07:19
You can also explore other types of colors if you wish.
Excelchat Expert 18/12/2017 - 07:20
After I've entered the date and selected the format of color you want it to be, you will now click "OK."
Excelchat Expert 18/12/2017 - 07:21
After that, it will automatically highlight all dates that are lower or earlier that you've entered.
Excelchat Expert 18/12/2017 - 07:21
Like what happened in the example.
Excelchat Expert 18/12/2017 - 07:21
I hope this example helped your problem.
Excelchat Expert 18/12/2017 - 07:21
Thank you for using Got It Pro-Excel. Please give your kind feedback for our service. Have a great day ahead.

This is the output file from the real Excelchat help session:
This is an example of the expert help you can get. It contains no private user information.

Get instant expert help with Excel and Google Sheets

Post your problem and you’ll get expert help in seconds.

Your message must be at least 40 characters
Your privacy is guaranteed. Your session will not be used for blog unless you give us persmission.