Submitted by David_H on 2020/06/20 21:57
 I want the Done field to be a color when it is has (any) date. I've tried [Done]="<>0" and [Done]="<>" and [Done]<>0 and numerous other variations with no luck. I do RTFM, but no luck.
 
Thanks

Comments

This first one below works here:
 
 
I believe that this:
Done=<>0
would be used in a different field to make it conditional on Done field
(but havent used this much in a long time)

David_H

2020/06/21 18:04

Permalink

 Thank you Tom! That did it!

Tom

2020/06/22 13:32

Permalink

[quote=David_H]
 Thank you Tom! That did it!
[/quote]
 Great :-)
 
[quote=Tom]
I believe that this:
Done=<>0
would be used in a different field to make it conditional on Done field
(but havent used this much in a long time)
[/quote]
This one I couldnt get to work. I added it to a field named 'Project'
Done=0 works as expected (field gets highlighted when 'Done' field is empty)
but
Done=<>0 has no effect (IIUC it should highlight Project field when Done field has content)
 
Anyone got any ideas on that one?
 
EDIT// relevant link Conditional Formatting