Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Conditional Format colour codes
- Thread starter NeilT123
- Start date
TheAceMan1
Programmer
How are ya NeilT123 . . .
Not sure of the exact values, but you can get the values for any color from the [blue]Color Dialog[/blue]. Just put cursor on the [blue]ForeGround/Background[/blue] property line of any textbox and click the three ellipses just to the right! . . .
See Ya! . . . . . .
Not sure of the exact values, but you can get the values for any color from the [blue]Color Dialog[/blue]. Just put cursor on the [blue]ForeGround/Background[/blue] property line of any textbox and click the three ellipses just to the right! . . .
MichaelRed
Programmer
Search these (Tek-Tips) fora for "RGB(" which is a intrinsic function to VB(A). It can be used to generate the (Long) vlaue of a color from the three (Red, Green, Blue) values. In some of these threads, you should find a complimentart function to take the Long color number and return the RGB components.
COnditional formatting can (with a small effort) be set to use and (valid) color value, so the two functions can provide you with the entire range of possible colors for use in the conditional formats.
MichaelRed
COnditional formatting can (with a small effort) be set to use and (valid) color value, so the two functions can provide you with the entire range of possible colors for use in the conditional formats.
MichaelRed
- Status
Similar threads
- Locked
- Question
- Locked
- Question