Does ir mean that only yes/no field coud be formated -- I want to the color of the cell change in the date field when there is the value entered in that cell (date) -- blank cells will have no changed color.
Does ir mean that only yes/no field coud be formated -- I want to the color of the cell change in the date field when there is the value entered in that cell (date) -- blank cells will have no changed color.
[/quote]
I havent done this myself but have you tried to use (from Item Formatting)
"=0" means that the Yes/No field is "Null" --> "not ticked".
"<>0" means that the Yes/No field is "not Null" --> ticked.
I'm presuming that it might also work thus:-
"=0" means the field is empty etc.
maybe best to try out on a sample grid though (that's a disclaimer!)
Eureka! It finally works. I put <>0 in "criteria" cell but have to tick "Use " cell. I'm so glad I finally completed something and not just only a part of it.
One more thing -- would it be possible for the text in the same date field to change when the corresponding HTML pane (the HTML pane for the item) is not blank?
I've been waiting for an answer, but maybe you didn't have time or my question was too stupid. Let me try again: how do I format conditionally a cell (which is in this case a date field) so when I entered the date into that cell the color (back, fore, doesn't matter) will change?
Also can I format conditionally this cell (let's say that it is a date filed, too) so that when corresponding HTML pane is not blank, the color (back, fore, desn't matter) will change. How do I do it?
Jay
PS: I tried to do it with entering in the""criteria" cell "name of the field" =0 and color code in the"formats" cell, and checking "Use" cell and it seemed to work, but that's how far I could go with it. When I typed "name of the field" is not null in the "criteria" cell it did not work. Similarly typing HTML is not null in "criteria" cell did not work.
1. But that means that it is not possible to set up the conditional formatting of the cell that it would automatically change its color (fore or back) when I write something in HTML pane? Am I right?
2. I still don't know if it is possible to set up coditional formating for my date field so that the cell will automatically change its color (fore or back) when Ienter a date in that cell?
1. But that means that it is not possible to set up the conditional formatting of the cell that it would automatically change its color (fore or back) when I write something in HTML pane? Am I right?
2. I still don't know if it is possible to set up coditional formating for my date field so that the cell will automatically change its color (fore or back) when Ienter a date in that cell?
[/quote]
I'll start with #2
2.
when I just tried to do what I suggested above, it worked here (basically I copied it from the screenshot on the Item Formatting page
using
"=0" means that the field is "Null" (empty)
"<>0" means that the field is "not Null"
1. if I understand correctly, that is exactly what it will do -
when you write in (previously empty) html pane the itemHas HTML field will be automatically ticked, you can set up your conditional formatting based on that
... if you want the formating to be conditioned by another field (here a value in the SQLNotes field will affect the Notes field formating), you can add a specific field name before the "<>0" or "=0".
Comments
I'm presuming that it might also work thus:-