**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.*