Replies

Finally its working..what a relief..Thanks a zillion Andrew coz solved this..but I’m still wondering..if this method can also applied basedon grades..please refer to attachment..many thanks again

Yup..you came almost perfect Legare..but you
still miss 1 thing..please refer to attachment.many thanks

Thanks for the response again..but you guys still miss 1 thing..

So in order to answer legare question..i try to elaborate it.the details that i can..lol..as i said b4..i’m also got headache because of this..

1. What is the difference between “no marks entered” and empty?
==> if no cells fill with marks at all=empty (a1,c1e1), it should be grey
==> if either one cells fills(one single cell is enuff) , and the marks (1-100) , it should be red
==> if two cells fills , and the marks is (1-100), it also should be red
==> if three cells fills , and the marks is equal to 40 and above, it should be blue

ps:

* the student must get the minimum marks=40(a1,c1,e1) in all subjects in order to get pass=blue(whole range)

* if they miss 1 subject(fail)=below40(a1,c1,e1) in any subject, they will get fail=red(whole range)

* if no student marks entered=empty , it turn to grey(whole range)

So the conclusion is : student must pass all subject(a1,c1,e1) to get =blue
i hope you guys understand now and can help me again to solve this saga..

2- What color do you want it to be if one is empty, one is below 40, and one is above 40?
the answer is red

Thanks for the info Legare..its quite helpful..

Thanks and Sorry John..i’ve got all messed up..the truth is the wb that i sent earlier is not an update
version of what i really need..but you response too fast..sorry to get you also in this mess..this is really what i am for..haha..i’m really screwed up by this situation..please refer to this attachment..this time its for real

Thanks for the response Legare..but I think you
dont understand my real question..I’m also getting headache trying to explain this situation.Please refer to my attachment for details.Many thanks..and hope you can help me again and again..LOL..regards

Thanks Mr.Coleman..maybe this is what i’m looking for..so far so good..regards

Sub Full()
Application.ScreenUpdating = False
Application.CommandBars(“Standard”).Visible = False
Application.CommandBars(“Formatting”).Visible = False
Application.CommandBars(“Drawing”).Visible = False
Application.DisplayFormulaBar = False
Application.DisplayStatusBar = False

Dim NumSheets
NumSheets = Sheets.Count
Dim i
For i = 1 To NumSheets
Sheets(i).Select
With ActiveWindow
.DisplayGridlines = False
.DisplayHeadings = False
.DisplayWorkbookTabs = False
.DisplayHorizontalScrollBar = False
.DisplayVerticalScrollBar = False
End With
Next i
Sheets(1).Select
End Sub

Thanks but its not what I aim for..
above code works fine until I decided
to hide some of my sheets..it will
return error and the code will not run..
Anybody know how can I use above code
and still can hide some of my sheets
that I prefered and I can chose which
sheet should always be open on the opening..many thanks
should

Thanks John..it works like charms.thanks again

IF(OR(C2<40,E2<40,G2<40),"FAIL","PASS")

this formula is working..but it still shows
fail when there is no data..how can it be empty
when there is no data across the range filled..many thanks again..

Thanks John..

Thanks..it works like a charm..

but still looking for the code to sort the data range without unprotect it first ..is it possible or is it just a dream..lol..thanks a bunch guys..

Addition to my previous reply..

What I meant by using your code Andrew
is how can I manipulate your code if
the protected sheet contain password..
let say “123” your code that your provide
will prompt for password if the sheet
contains pasword.how can i overcome this
and the macro will unprotect it without
prompt for password and after finished, it
will protect again the sheet with “123”
password..hope you can understand my question
andrew..thanks again..

i’m thinking like this..lol..

for Andrew solution..it just a thought okay..
let say the sheet is protected with password
let say “123”..so how can i use your code..

OR

i still hunt for this..
can you guys figure a way..i meant how
to sort data range on a protected sheet
because i have saw a guy do this..sort data
range on a protected sheet without unprotect
the sheet first.many thanks guy..hope you can
help me on this..appreciate it very much and
zillion thanks