Registration date
September 23, 2012
Last seen
December 13, 2018
Contributions
2,403
Gender
Male
Signature
Thanks & Regards Zohaib Raza

Conditional formatting: change fontcolor based on another cell [Solved]

Hello, I have "text" in cell B1. However, I want the font color to change based on the numerical value in cell B8; so if the number in cell B8 ranges between 1-10, I want the text in B1 to change to GREEN; if the number in B8 ranges 11-20, I want the text in B1 to change to BLUE; if the number in B8 is greater than 20, I want the text... Read more

My Acer laptop shut downs whenever the power chord is unplugged

Hi, I have got a problem with my Acer laptop. Since last two months, whenever the light goes out or the power chord is unplugged, the laptop shuts down. It's giving me a hard time. I can't work without light. I need electricity to turn on my laptop and sometimes after work, while the adapter is plugged in, it shutdowns. Please sugge... Read more

How to use conditional format based on text? [Solved/Closed]

Hello, I want a cell to change color if another cell contains the words "first aid". The text comes down from a drop down list and could read "First Aid" or "sleepover/first aid". If the cell has "first aid" in it, I want the other cell to change color. I can get it to work if using formula f13=first aid but it won't change colo... Read more

My laptop Bluetooth is not working [Solved/Closed]

Hello, I recently bought a Dell Inspiron 3520 laptop and I am unable to use Bluetooth device. Although the Bluetooth icon is displayed in task bar, when I tried to scan for Bluetooth devices, it doesn't locate even the wireless network. The drivers for Bluetooth are working properly. What could be the problem? Please help! Read more

Excel function question

Hello, Which spreadsheet function in Excel will display 6 as the output in the following formula? =(36)

No Audio Output Device Is Installed [Solved]

Hello, I upgraded from windows xp to 7 professional everything is fine except no sound. On bottom right corner there is speaker with a x in red circle. In device manager "Multimedia audio controller" and "High Definition Audio Controller" Show a n error...Please help My mother board is Gigabyte GCM-s2l Configuration: Windows 7... Read more

My Dell Inspiron laptop is not starting up [Solved/Closed]

Hey, there any one plz give me idea about my problem with my laptop, last night I shut down my laptop properly and the next day evening it was not getting start,battry is ok and it is showing charging but it is nt geting start even without battry...anybuddy can you plz help me??? System Configuration: / Opera 9.80 Read more

My computer beeps 3 times and monitor has no signal!! [Solved/Closed]

Hello, hey I have a dell dimension 4400 and I just got his new video card called ati radeon 9700 and I opened up my pc and swiched that video card with the old one I had ! and I took the molex connecter ithnk called p7 andi plugged on the side of my video card and closed my computer and plugged everything in and all of a sudden I plug i... Read more

External USB hard drive doesn't show up in My Computer [Solved/Closed]

Hello, My External USB Hard Drive doesn't show up in My Computer Win 7 64bit. I've just received my Western Element 2,5Tb today. When I first plugged it in, it worked normally. But due to my over-excitement, I copied too much files at the same time and it wasn't working anymore. I regretted doing this immediately. I have searche... Read more

Some keys stopped working i.e.B, N, Space, Arrows [Solved/Closed]

Hi, Suddenly some keys on my dell vostro 1015 (such as B, N, SPACE BAR, ARROWS), stopped working without any reason. Its been 1month and yet I haven't found any solution for it.I am not getting time to get it repaired.i need help from you guyz. 1day before when it stopped working, installed a game and next day of it, keys stopped worki... Read more

To get audio out from laptop while HDMI used [Solved/Closed]

Hello, I am using HP Pavilion dm4 laptop. Today I have bought 23 inch LED Samsung(S23B350) monitor which has 1 HDMI and 1 VG]. No inbuilt speaker with monitor. I have connected my laptop with Samsung through the Hdmi. Since Samsung monitor don't have the speaker there is no audio. I am trying to take the audio out from my laptop an... Read more

SATA HDD not detected in bios. But sometimes it does. [Solved/Closed]

Hello, recently my pc has started malfunctioning. windows will not boot! when I enter setup (bios) I cant see my hdd. sometimes its there and sometimes not! when I boot to repair disk (when the hdd is detected) and run startup repair it shows like this : "root cause found : the partion table does not have a valid system partition". and ... Read more

ASUS laptop internal speaker is not working. [Solved/Closed]

Hello, my ASUS laptop speaker is two weeks old. the sound didn't work after I put my laptop in 'sleep' mode. even by using the headphone the sound also didn't work. I'm using Windows 8. please help me.. :( Configuration: Windows 8 / Chrome 23.0.1271.95

Computer does not boot, stuck in bios boot screen [Solved/Closed]

Hi, My computer, one day, when I switched it on, lost few icons on the desktop and became very very slow. I restarted it. But there was no change. So I decided to restore it to some day before so that I might get my last good configuration, but then problems began. I pressed F8 and selected the Safe mode, but it showed some file n... Read more

Excel compare and return result

Hello, I have a set of field to compare in 2 different spreadsheet out of which any match will then check and return for a specific value in another column. E.g. Compare the name and if the role exist for the name, return yes. If not, return no. Spreadsheet A: Name Role Mary Secretary Mary HOD Jane Secretary Jane HOD J... Read more