Conditional Formatting on YES/NO (True/False)

[jimmy.guilfoyle]

Hi Folks

1st Post here.

Getting back into access again from a few years back and getting to grips with 2007 (yikes)

I have been playing with conditional formatting on a report.

Here is a snapshot below

So in the outstanding field (which comes froma crosstab query) Im ok with conditional formatting.

Q1

However how do I get the field to show a conditional format when empty i.e AT3 has nothing outstanding. Its an empty cell in the crosstab source, so there is no value.

Q2

The NBR YES/NO options above are sourced from a table (Tick option). Ive started using this feature rather than yes/no as its very usefull. However, how do I get to use conditional formating on these i.e if True (Ticked) turn green.

I would really apreciate if someone can help me complete this task

Many thanks Jimmy (From Isle of Bute, Scotland, But in working in Dubai)

 

[Alisa]

Try setting one of your conditional formats to expression, and then for the expression use is null.