conditional highlight in orange 2

[VE]

Hello,

I'm using CR 2008 and I was asked to highlight a field in orange if it was in a certain range. I've tried crorange and I tried searching the help files.

How would I create a conditional highlight using a "custom" color?

Thank you for your help
VE

 

[briangriffin]

Right click on the field: Format Field - go to the Font tab. Click the X2 button and enter this formula:

rgb(255,127,0)

You can put any valid RGB combination, and you'll find those values here:

http://cloford.com/resources/colours/500col.htm

 

[Turkbear]

Hi,
Look up the code for the color you want and use the

RGB(nn,nn,nn)
use 0-255 for each value
function instead of theCR color variable name

Here is a very handy one:

http://www.w3schools.com/html/html_colornames.asp

Note: Hex values shown, convert to decimal,like
for a nice Orange the HEX is FF8C00 so use:

RGB(255,140,00)


Here is a nice Converter site:

http://easycalculation.com/hex-converter.php

To Paraphrase:"The Help you get is proportional to the Help you give.."

 

[Turkbear]

Hi,
Well, more help is better than less ..

briangriffin's chart has the decimal values ( no conversion needed!), and the one I referenced has more variations in shades of various colors.

Both should get you what you want.





To Paraphrase:"The Help you get is proportional to the Help you give.."

 

[VE]

Awesome, thank you!!

 

[Turkbear]

Hi,
You're welcome, glad to help



To Paraphrase:"The Help you get is proportional to the Help you give.."