If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
conditional formatting coleman
i have in Coleman c numbers and in Coleman d numbers and i want to know if it
is possible to make throe conditional formatting not throe vba that if b is than c and should work for the full Coleman lets say if b1 is then c1 and if b500 is then c500 |
#2
|
|||
|
|||
conditional formatting coleman
if you have 2007. click on b1 or c1; which ever you are trying to format.
click conditional formatting then new rule. Then click on "format only cells that contain", then click the drop down menu and select great than or less than, then click the other cell, either b1 or c1; depending on what you started with. format the cell the way you want. make sure that none of the cell values are locked. (e.i. $B$1, make sure it reads B1). Then click on the cell you formatted. then click on conditional formatting and select manage rules. Then click inside the box on the right and select the desired cells that you wish to format. "person" wrote: i have in Coleman c numbers and in Coleman d numbers and i want to know if it is possible to make throe conditional formatting not throe vba that if b is than c and should work for the full Coleman lets say if b1 is then c1 and if b500 is then c500 |
Thread Tools | |
Display Modes | |
|
|