Conditional format cells in a column based on a formula and 2 criteria

distillerjunkie

New member
Joined
Mar 16, 2016
Messages
33
Reaction score
0
Points
0
I have a column B conditionally formatted to format my cells in that column a certain color if the date is 90 days or older. What I need it to have these cells ONLY conditionally formatted IF another column F says "Investigating" or "Implementing."

Please help!
 
Perhaps try = and($B1>=(today()-90),or($F1={investigating","implementing"}))

(I'm not sure about what you mean with"90 days or older", so you might need to tweak the today()-90 part a bit)
 
Formula location

Here is a screen shot of Where I put the formula.

attachment.php

Which error did you get? Where did you the formula? Do your regional settings use commas or semi colons?
 

Attachments

  • HIT.PNG
    HIT.PNG
    54.5 KB · Views: 40
attachment.php


Sorry. First post is wrong screenshot. This is the correct Screen shot of where I put the conditional Formatting and error.
 

Attachments

  • HIT_ConditionalFormatting.PNG
    HIT_ConditionalFormatting.PNG
    93.2 KB · Views: 41
Try = and($B2>=(today()-90),or($F2="investigating",$F2="implementing"))

(don't forget B52 contains a text string...)
 
Back
Top