Conditional formatting based on numerical values using different color

Right click on a column containing 10 ,20 and 30 and format cells,click custom and type

[BLUE][=>30]00;[MAGENTA][=>20]00;[green]00

and you are done.

you can not change the color of any cell using traditional method

Java not working in Internet Explorer after installing java on Windows 8 solved

I have faced this error,fortunately found the solve.

Reinstall Java using offline version.(just the jre in the second time works for me)

    Go to the Windows offline page

    On the download page, click Agree and Start Free Java Download

    If you've already installed the version, you will see a message, This software has already been installed on your computer. Would you like to reinstall it?

    Click Yes and reinstall,and you are done.

source:https://java.com/en/download/help/ie_tips.xml

What is PAE Kernel

(PAE) stand for Physical Address Extension. It's a feature of x86 and x86-64 processors that allows more than 4 Gigabytes of physical memory to be used in 32-bit systems.

To enable PAE, open terminal and type the following command:

sudo apt-get install linux-headers-server linux-image-server linux-server

reboot.

Windows 7 network/internet slow resolved

A friend of mine kept saying networking is slow in windows 7 and over the years I have heard it from many people,so some fixes I found,

run->cmd(with admin privilege)->netsh interface tcp show global

in the output if the Receive Windows Auto-Tuning Level : normal

then

netsh interface tcp set global autotuning=disabled

now see the output of netsh interface tcp show global

Receive Windows Auto-Tuning Level : disabled should be showing up

Remote differential compression should be off as old operating systems does not support this feature,it basically compresses data over the network

to do this you have to go to

control panel-programs-turn windows feature on or off and then clear the box beside remote differential compression

disable ipv6 from your lan adapter at it's properties

set duplex settings to 10mb/s half duplex

see for suspicious process in task manager

ipconfig /flushdns,net stop dnscache,net start dnscache commands should be useful,at the end netsh winsock reset should get the job done although a restart is required.

try using ccleaner for clean up of temporary files and registry clean

try using malwarebytes for a quick scan

go to msconfig and delete unnecessary programs at start up

make windows theme the classic one so that some ram frees up

for advanced scanning use hijackthis software

I guess that's it then.


Sourav Bhattacharya

PHP & MySQL Faculty(for the last 6 years) at Growmax Infotech

Reset chrome,firefox and internet explorer

Browsers gave me lots of headache in the past,so here how you reset them

In case of firefox,

help->troubleshooting information->reset firefox

In case of Chrome

settings->show advanced settings->reset browser settings.

In case of Internet Explorer

run->inetcpl.cpl

then on general tab delete everything

then advanced-lick reset-click delete personal settings and then click reset


Sourav Bhattacharya

gnu/linux,python,php,perl trainer for the last 6 years.