Home

conditional formatting help!

%3CLINGO-SUB%20id%3D%22lingo-sub-786074%22%20slang%3D%22en-US%22%3Econditional%20formatting%20help!%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-786074%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%202%20columns.%20I%20would%20like%20to%20highlight%20in%20red%20the%20first%20column%20IF%20it's%20blank%20AND%20the%20second%20column's%20date%20is%207%20days%20or%20greater%20from%20the%20date%20in%20that%20cell.%20For%20example%20column%201%2C%20row%201%20is%20blank%20and%20column%202%2C%20row%201%20says%207%2F1%2F19.%207%2F1%2F19%20is%20greater%20than%207%20days%20old%20so%20I'd%20like%20the%20blank%20cell%20to%20become%20red%2C%20signaling%20that%20the%20blank%20needs%20to%26nbsp%3B%20be%20addressed%20because%20the%20date%20is%20over%207%20days%20old%20from%20when%20initiallentered.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-786074%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-786082%22%20slang%3D%22en-US%22%3ERe%3A%20conditional%20formatting%20help!%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-786082%22%20slang%3D%22en-US%22%3E%3CP%3EI%20should%20also%20have%20stated%20that%20once%20the%20blank%20is%20filled%20in%2C%20I'd%20like%20the%20red%20to%20disappear.%20Thanks%20again!!!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-786313%22%20slang%3D%22en-US%22%3ERe%3A%20conditional%20formatting%20help!%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-786313%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F386480%22%20target%3D%22_blank%22%3E%40Rlange%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EYou%20may%20apply%20to%20first%20column%20conditional%20formatting%20rule%20with%20formula%20like%3C%2FP%3E%0A%3CPRE%20class%3D%22lia-code-sample%20language-ruby%22%3E%3CCODE%3E%3DISBLANK(%24A1)*(TODAY()-%24B1%26gt%3B7)%3C%2FCODE%3E%3C%2FPRE%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F125448i9515D43828022D30%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20alt%3D%22clipboard_image_0.png%22%20title%3D%22clipboard_image_0.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
Rlange
New Contributor

I have 2 columns. I would like to highlight in red the first column IF it's blank AND the second column's date is 7 days or greater from the date in that cell. For example column 1, row 1 is blank and column 2, row 1 says 7/1/19. 7/1/19 is greater than 7 days old so I'd like the blank cell to become red, signaling that the blank needs to  be addressed because the date is over 7 days old from when initiallentered.

2 Replies

I should also have stated that once the blank is filled in, I'd like the red to disappear. Thanks again!!!

@Rlange 

You may apply to first column conditional formatting rule with formula like

=ISBLANK($A1)*(TODAY()-$B1>7)

clipboard_image_0.png

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
18 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
11 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies