conditional formating

[rudy]

I am trying to highlight the output of a field to display something
similar to conditional formating. Would prefer to display the result
with a code instead of a colored font or colored background for the
sake of using a black and white printer.

i.e. if >= 20 then H for highly skilled or >= 15 then S for Skilled

Even though the colors work there is only three options to select from
under Conditional Formatiting (unless there's a way to increase this
to 5).

I was trying something like this =IIf(([TEXT922]))>=27,H,>=23,S
but it does not work. Any suggestions out there?

Thanks,
Rudy Castro

[Jeff]

Hi Rudy

Your statement should be

= IIf([TEXT922] >= 27, "H", IIf([TEXT922] >= 23, "S"))

However, I am not sure if this will work in Conditional Formatting as I
don't believe it will replace the value of TEXT922 with the code.

Jeff

"rudy" <rc******@satx.rr.com> wrote in message
news:8b**************************@posting.google.c om...

I am trying to highlight the output of a field to display something
similar to conditional formating. Would prefer to display the result
with a code instead of a colored font or colored background for the
sake of using a black and white printer.

i.e. if >= 20 then H for highly skilled or >= 15 then S for Skilled

Even though the colors work there is only three options to select from
under Conditional Formatiting (unless there's a way to increase this
to 5).

I was trying something like this =IIf(([TEXT922]))>=27,H,>=23,S
but it does not work. Any suggestions out there?

Thanks,
Rudy Castro

[rudy]

Thanks Jeff it worked.

"Jeff" <je************@asken.com.au> wrote in message news:<RF****************@news.optus.net.au>...

Hi Rudy

Your statement should be

= IIf([TEXT922] >= 27, "H", IIf([TEXT922] >= 23, "S"))

However, I am not sure if this will work in Conditional Formatting as I
don't believe it will replace the value of TEXT922 with the code.

Jeff

"rudy" <rc******@satx.rr.com> wrote in message
news:8b**************************@posting.google.c om...

I am trying to highlight the output of a field to display something
similar to conditional formating. Would prefer to display the result
with a code instead of a colored font or colored background for the
sake of using a black and white printer.

i.e. if >= 20 then H for highly skilled or >= 15 then S for Skilled

Even though the colors work there is only three options to select from
under Conditional Formatiting (unless there's a way to increase this
to 5).

I was trying something like this =IIf(([TEXT922]))>=27,H,>=23,S
but it does not work. Any suggestions out there?

Thanks,
Rudy Castro