| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditional format based off of a logical if statement
hello,
I need cell H5 to turn red, if I5="y" and H5 is less than 90 days from today date. I could get it to work for the =i5="y" but I cant seem to get the second piece to work,(=H5-today()<91) I tired it as a second condition and also trying to put it all as one condition. Any suggestions. I am using Exel 03 Thanks |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Conditional format based off of a logical if statement
You want to use an AND statement something like this...
=and(i5="y", H5-today()<91) -- HTH... Jim Thomlinson "cyndi" wrote: hello, I need cell H5 to turn red, if I5="y" and H5 is less than 90 days from today date. I could get it to work for the =i5="y" but I cant seem to get the second piece to work,(=H5-today()<91) I tired it as a second condition and also trying to put it all as one condition. Any suggestions. I am using Exel 03 Thanks |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Conditional format based off of a logical if statement
Hi,
Try something like this: =AND(I5="yes",H5-TODAY()<=90) HTH Jean-Guy "cyndi" wrote: hello, I need cell H5 to turn red, if I5="y" and H5 is less than 90 days from today date. I could get it to work for the =i5="y" but I cant seem to get the second piece to work,(=H5-today()<91) I tired it as a second condition and also trying to put it all as one condition. Any suggestions. I am using Exel 03 Thanks |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Conditional format based off of a logical if statement
you guys are the best, it worked, figures I was just putting the and in the
wrong place!! Thank for all your help! "pinmaster" wrote: Hi, Try something like this: =AND(I5="yes",H5-TODAY()<=90) HTH Jean-Guy "cyndi" wrote: hello, I need cell H5 to turn red, if I5="y" and H5 is less than 90 days from today date. I could get it to work for the =i5="y" but I cant seem to get the second piece to work,(=H5-today()<91) I tired it as a second condition and also trying to put it all as one condition. Any suggestions. I am using Exel 03 Thanks |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| IF Statement based on Conditional format | Excel Discussion (Misc queries) | |||
| Logical Statement | Excel Discussion (Misc queries) | |||
| If statement based on currency format | Excel Worksheet Functions | |||
| Conditional formatting based on if statement. | Excel Worksheet Functions | |||
| How do I set a Conditional Format for ROWs based on the value of . | Excel Discussion (Misc queries) | |||
Linear Mode
