In a range of cells starting with cell E46:
The formula, =TODAY()-E46>365, works to format dates greater than 365 days.
The formula, =ISTEXT(E46), works to format text.
The problem: how to combine these formulae to format cells in the range with dates > 365 days, AND cells with text. If a cell has a date > 365 days and a different cell has text, they both would be formatted.
er...
=OR(TODAY()-E46>365,ISTEXT(E46)
?
You should hit F5, because chances are I've edited this post at least 5 times.
Example of Array Formulas
Click the * below on any post that helped you.Originally Posted by Jacc
Entered the formula =OR(TODAY()-E46>365,ISTEXT(E46)). Dates format, but not the cells with text. Cells are formatted date, could that be an issue?
The only way I could make this work was to split into two rules. Apparently conditional formatting does not allow an "or" formula.....
The OR() formula should work in conditional formatting, the issue is somewhere else....not sure where though
Can you post a desensitized sample of the workbook?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks