tahir
|
Excel helpNeed help with a conditional format:
the cell with the formula is F8
If( M8>"" ,"SENT",F8 )
2 issues:
1. For some reason it doesn't like M8>"", M8>0 works but that's not what I want
2. It doesn't like F8, it wraps it in quotes but what I'm after is for the cell value to remain unchanged if the condition is false...
|
tahir
|
M8 is a date value if that helps
|
Treacodactyl
|
Does something like M8 not NULL work?
|
tahir
|
| Treacodactyl wrote: | | Does something like M8 not NULL work? |
Dunno does not null exist in Excel? Will give it a go
|
tahir
|
Nope, doesn't like it.
|
Treacodactyl
|
I haven't got Excel but OpenOffice doesn't like your line if I use commas but is happy with semi-colons, so If(M8>"";"SENT";F8 ) works.
|
no-witty-name
|
Try using
=IF(M8>DATEVALUE("01/01/2001"),"SENT",F
or a date before 2001 if you need to go back further
|
no-witty-name
|
Not sure why I got a smiley face, that should be 8 instead
|
tahir
|
Thanks guys have found another (much cruder) solution but this may come in handy too.
|
Northern_Lad
|
I didn't think that conditional formatting let you put result text in the cell, only effect the formatting.
However, that formula with an '=' before it in each of the cells should have worked.
|
