Search : in
By :

IF= CHANGE THE COLOUR OF THE LINE ?

Last answer on Jul 15, 2009 6:27:41 am BST hchwhy, on Jul 14, 2009 7:14:52 pm BST 
 Report this message to moderators

Hello,
I'm having a bit of trouble, what i need is if a box says yes the whole line that its on goes red and if it says no then the line goes green. I really dont know what to write here but you're help is much appreciated and by the way im on office 2007
Thank you very much xx

Configuration: Windows Vista Internet Explorer 8.0

Best answers for « IF= CHANGE THE COLOUR OF THE LINE ? » in :
How to read a file line by line ShowHow to read a file line by line Intro Tips Bonus Intro One of the most common errors of learning scripts bash on GNU / Linux is to read a file line by line, is to use a loop "for" (for line in $ (cat file.txt) do. ..), which in this...
Install Dofus under Linux ShowDownload Dofus Decompress the file Use Dofus Online Install Dofus under Linux Download Dofus For example, if the directory link for the download is set as /home/USERNAME/dofus, you should make use of the command mkdir $HOME/dofus to...
WPA / WEP forgotten or lost? ShowWPA / WEP forgotten or lost? Change the WEP key Reset WiFi router If you cannot connect to your wireless network because you have forgotten the WEP key or WPA, you can solve it by changing your access point or router WiFi. Change...
Download Broadcom Ethernet NIC NetLink Driver for Linux ShowThese drivers from Broadcom( BCM57xx/NetXtreme Broadcom NetLink BCM57xx WHQL) are compatible with the following chipsets: BCM 5781 BCM 5786 BCM 5787 BCM 5788 BCM 5789 These drivers work on Linux (tg3) ,if your are searching for the same...
Change factors ShowChange factors The origin of the change is linked to the realisation of a gap between an organisation's goals and the means of achieving those goals, i.e. the business operation. The following are those factors that lead to this...
Linux commands ShowTable of main Linux commands Command Description DOS equivalent ls lists the content of a directory dir cd change directory cd cd .. parent directory cd.. mkdir creates a new...
Worksheet - Cells ShowThe Concept of a Cell A "cell" is the intersection between a line (horizontal) and a column (vertical) on a worksheet. Thus, the name of the line combined with the name of the column gives the cell's coordinates (the term address is sometimes also...

1

 mubashir aziz, on Jul 15, 2009 6:27:41 am BST

This is because of using Conditional Formatting. you can just explore it thru excel help ......

suppose your data in A1 then in Conditional Formatting you can write Formula is A1="Yes" and apply the format .....

Never ashamed to get or give Advise.
Muhammad Mubashir Aziz , Lodhran, Pakistan

Reply to mubashir aziz