misc questions...urgent reply required pls help

  • Thread starter Thread starter murtaza
  • Start date Start date
M

murtaza

hi there , can some one tell me that...


how many worksheets maximum can a workbook have?

how we can add more formats to conditonal formatting it
currently works upto 3 formats


can we change the color of the cell on inserting any
certain value


what about running countif fuction on numeric value in a
column
 
Hi murtaza

1)
The maximum number of sheets in a workbook is limited by available memory.
The max number of sheets that can, by default, be in a newly created
workbook is 255


2)
You can't, you need VBA

You can use the change event with "Select Case"

3)
Here is a example that use the Change event of the worksheet
Right click on a sheet tab and choose view code.
Paste the event in there and press Alt-Q to go back to Excel.

This example will only work in column A

Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Column = 1 Then
Dim Number
Number = Target.Value
Select Case Number
Case 1 To 5
Target.Interior.ColorIndex = 3
Case 6, 7, 8
Target.Interior.ColorIndex = 5
Case 9 To 10
Target.Interior.ColorIndex = 8
Case Else
Target.Interior.ColorIndex = 10
End Select
End If
End Sub

4)
=COUNTIF(A:A,2)
 
hhhhhhhhhhhhhhhhahaaaaaaaah :)


very well said,, sir, but these are the questions i noted
instead of asking them individually, listen can u give me
a better answer of my questions?

i''ll relly appreciate..

thanks
murtaza
 
Murtaza,

If these are homework questions, then I will provide direction, but not the
answers themselves. Take a look at Excel and see what you can find for
yourself. Without meaning to be rude, your questions aren't terribly
complex, and doing a look through Excel's help functionality (press F1 or go
to Help) will probably give you the answers that you need with minimal
effort.

Also, take a look at the microsoft website - they have a very good search
engine that may also help you. I'd recommend using their search engine, the
Knowledge Base site
(http://support.microsoft.com/default.aspx?scid=FH;[LN];KBHOWTO) or Technet
if you really want to get detailed information.

Good luck,
Katherine
 
Back
Top