# Excel - IF Function Problem - Expert Solution

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

I need to subtract two dates and if the numerical answer is less than 30 I need to Conditionally format one particular column to turn red on each one of those scenarios.
Solved by X. B. in 17 mins
This is the chat thread from the real Excelchat help session. It contains no private user information.
Excelchat Expert 26/07/2018 - 04:10
Hi there!
User 26/07/2018 - 04:10
DESCRIPTION: I need to subtract two dates and if the numerical answer is less than 30 I need to Conditionally format one particular column to turn red on each one of those scenarios.
User 26/07/2018 - 04:10
did you see that question
Excelchat Expert 26/07/2018 - 04:10
So you need to subtract two cells that are dates, and if the result is less than 30 days, then that cell needs to be colored red?
User 26/07/2018 - 04:11
sure
Excelchat Expert 26/07/2018 - 04:11
Yep sure did - do you have a file you would like me to add this logic to?
User 26/07/2018 - 04:11
no
Excelchat Expert 26/07/2018 - 04:11
Are you using Excel or google sheets?
Excelchat Expert 26/07/2018 - 04:12
Ah perfect thank you
User 26/07/2018 - 04:12
Excel
User 26/07/2018 - 04:12
Show me how to turn column C red when C Minus B is less than 30
Excelchat Expert 26/07/2018 - 04:12
You will have to go into the conditional formatting menu within Excel to set up that part, but I can walk you through it
User 26/07/2018 - 04:13
k im there
User 26/07/2018 - 04:13
ok im there
Excelchat Expert 26/07/2018 - 04:14
Sorry. I am just creating it on my end.
Excelchat Expert 26/07/2018 - 04:14
Go to "New Rule"
Excelchat Expert 26/07/2018 - 04:14
Then "Use a Formula"
Excelchat Expert 26/07/2018 - 04:14
and then if you can give me a minute I will get you the rest.
User 26/07/2018 - 04:14
k
Excelchat Expert 26/07/2018 - 04:15
do you have just one cell selected right now? C3, for instance?
Excelchat Expert 26/07/2018 - 04:15
or the entire column?
User 26/07/2018 - 04:15
column
User 26/07/2018 - 04:16
c
Excelchat Expert 26/07/2018 - 04:16
can you please just select a single cell
Excelchat Expert 26/07/2018 - 04:16
The first date in your file on the right
Excelchat Expert 26/07/2018 - 04:16
then go back into the conditionmal format menu
Excelchat Expert 26/07/2018 - 04:16
new rule, use formula
Excelchat Expert 26/07/2018 - 04:17
sorry one second
Excelchat Expert 26/07/2018 - 04:18
=B2-A2<30
Excelchat Expert 26/07/2018 - 04:19
if you're in a different row other than 2
Excelchat Expert 26/07/2018 - 04:19
then change the number to whatever row you're in
Excelchat Expert 26/07/2018 - 04:19
perhaps 1
Excelchat Expert 26/07/2018 - 04:19
=B1-A1<30
Excelchat Expert 26/07/2018 - 04:20
it might be =C1-B1<30 if your data is in columns B and C
Excelchat Expert 26/07/2018 - 04:20
then you have to select a color that you want to use as the formatting
Excelchat Expert 26/07/2018 - 04:20
Click format, then select the red cell fill
Excelchat Expert 26/07/2018 - 04:21
Let me know if you get what I mean!
Excelchat Expert 26/07/2018 - 04:21
I can always send you a test file of this completed if you'd like
User 26/07/2018 - 04:23
how do i copy the conditional format
Excelchat Expert 26/07/2018 - 04:24
do you see the "Format Painter" button on the top left side of the screen?
User 26/07/2018 - 04:24
yep
Excelchat Expert 26/07/2018 - 04:24
make sure you have the cell selected, then click that painter button
Excelchat Expert 26/07/2018 - 04:24
then select all of the other cells and it will "paint" the format

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.