By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
454,290 Members | 1,761 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 454,290 IT Pros & Developers. It's quick & easy.

conditional formating

P: n/a
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
Nov 13 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
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

Nov 13 '05 #2

P: n/a
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

Nov 13 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.