[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
Re: excel conditional formatting
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>