Formulas

Genna

Distinguished
Jan 21, 2011
1
0
18,510
0
I am working on a spreadsheet and need to create a formula so that in the following instances the cell is highlighted:

If the date in cell A <= Today + 180 days AND The date in cell B <=A + 90 days. Then Cell 'A' will be highlighted.

I am not sure if this is possible.

Can anyone offer a solution?
 
G

Guest

Guest
This topic has been moved from the section Windows 2000/NT to section Applications by Grumpy9117
 
Thread starter Similar threads Forum Replies Date
S Apps General Discussion 5
A Apps General Discussion 3
M Apps General Discussion 6
H Apps General Discussion 13
U Apps General Discussion 1
M Apps General Discussion 4
N Apps General Discussion 7
P Apps General Discussion 1
P Apps General Discussion 4
D Apps General Discussion 2
W Apps General Discussion 2
J Apps General Discussion 2
Z Apps General Discussion 2
S Apps General Discussion 1
C Apps General Discussion 7
S Apps General Discussion 3
B Apps General Discussion 4
M Apps General Discussion 11
indyitguy Apps General Discussion 8
wanamingo Apps General Discussion 1

ASK THE COMMUNITY