A Microsoft Office (Excel, Word) forum. OfficeFrustration

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.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » General Discussion
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

conditional formatting coleman



 
 
Thread Tools Display Modes
  #1  
Old January 6th, 2010, 11:46 PM posted to microsoft.public.excel.misc
person
external usenet poster
 
Posts: 8
Default 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  
Old January 7th, 2010, 12:33 AM posted to microsoft.public.excel.misc
Todd
external usenet poster
 
Posts: 377
Default 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

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 09:57 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.