|
-
Jun 5th, 2007, 10:36 AM
#1
Thread Starter
Fanatic Member
 [RESOLVED] excel conditional formatting
Hi, I have an excel page full of numbers..I need to formatting up to ten numbers
I mean I want all my ten numbers to be of red colour.But
When I apply the formatting using the “Cell Value Is” method,
I am allowed up to three conditions.Is there a method of formatting more than 3 cells..Thanks
-
Jun 5th, 2007, 11:01 AM
#2
Fanatic Member
Re: excel conditional formatting
Last edited by VBAhack; Jun 5th, 2007 at 11:06 AM.
-
Jun 5th, 2007, 11:17 AM
#3
Thread Starter
Fanatic Member
Re: excel conditional formatting
Thanks VBhack..
Can we do the same coding it in Javascript?
such as in..
if random numbers that are created equal to 10,20,30,40,50,60 ,let these numbers be red...
thanks...
vb Code:
<html>
<body>
<script>
var dur=setInterval("onnumara()",1000)
var nom=0;
function onnumara()
{
for(a=1;a<=5;a++)
{
say1=Math.floor(Math.random()*40)+1;
document.getElementById("kutu1").innerHTML+=".."+say1+"..";
}
for(b=1;b<=5;b++)
{
say2=40+(Math.floor(Math.random()*40))+1;
document.getElementById("kutu1").innerHTML+=".."+"<font color=blue>"+say2+"</font>"+"..";
}
nom++;
document.getElementById("buto").value=nom+"..."+"yaz bakalım";
document.getElementById("kutu1").innerHTML+="<font color=red>"+"-------------"+nom+"</font>";
document.getElementById("kutu1").innerHTML+="<br>";
if(nom==50)
{
clearInterval(dur)
document.bgColor="pink";
}
}
</script>
<div id="kutu1"style="position:absolute;top:50;left:50;background-color:silver;width:100;"></div>
<input type=button id="buto" value="yazbakalım"onclick="onnumara()">
</body>
</html>
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|
Reply With Quote