Conditional formatting, backcolor determined by color value stored in a cell

[cewolf]

Greetings all

i would like to know if this is possible using VBA ( or other method)

i want to determine the back color o a cell based on a color value stored in another cell
in other word
backcolor of cell A = the value of cell B

sooooo if i change the numbers of cell B (which is color codes) , backcolor of cells A change accordingly and it will have the color specified in cell B




thanks a ton and half

 

[IfButOnly]

Hi cewolf

I think all you need is something like
me.CellA.backcolor = me.CellB
in CellB's AfterUpdate Event

Regards ... Peter

 

[cewolf]

thanks

forgot to mention that is it a continues form ...

so it has to do with conditional formatting

what you suggested will change the color of the cell for all records

what i want is to each record (Cell A) to have different back color depending on the correspondence color code cell (Cell B)

can it be done

thanks

 

[AlexN]

thanks

forgot to mention that is it a continues form ...

so it has to do with conditional formatting

what you suggested will change the color of the cell for all records

what i want is to each record (Cell A) to have different back color depending on the correspondence color code cell (Cell B)

can it be done

thanks

Something comes in mind....

Create an unbound text control (let's say txtColor, no default value)with the exact same attributes as CellA, hide it behind CellA and make CellA transparent.
Now give the CellB value to the background of txtColor.
It's a little quacky but I think it does the job.

A more complicated way comes with attached db....
HTH

 

[IfButOnly]

Here is a site that may also be of help

http://www.rogersaccesslibrary.com/forum/forum_posts.asp?TID=375

Peter