Flux rss
Search : in
By : Relevance Date Username
Statut : Not resolved

Conditionally changing row background color

PowerBuilder, on Thursday 2 October 2008 à 00:31:30
Hi

I want to change the background color of the rows in my Excel worksheet based on the value of a certain column named 'Status'.

Status can have around 7 values Conditional Formatting might not be the right choice. Following are the values that the status column can take

1. Resubmitted
2. Cancelled
3. In Progress
4. Pending
5. Cancelled
6.SignedOff
7.Testing

Each status should be indicated by a unique color for the row. Any help would be highly appreciated

Thanks
Configuration: Windows XP
Internet Explorer 6.0
Reply to PowerBuilder  Report this message to moderators Go to last message

1


  • 1
    This message seems useful, vote!
  • Ce message ne vous semble pas utile, votez !
  • Report this message to moderators
voicesms, on Thursday 2 October 2008 à 09:41:47
hello,

cant you get that option in the properties of the datasheet?
Reply to voicesms

2


  • This message seems useful, vote!
  • Report this message to moderators
 BALU, on Friday 31 October 2008 à 09:31:48
Hi
In formate select conditional formatting. In that select equalto and give the either one of you condition and formate the required color as you want. You can do like this for all your requirements by clikcing the add>>.

Check this link also.
http://www.techonthenet.com/excel/questions/cond_format1.php
regards
Balu.
Reply to BALU

Résultats pour Conditionally changing row background color

Restrict change of background Restrict change of background This tips has been raised out to show you how to configure and restrict the background change of your computer for specific purpose like company policy. Go to menu “Start” and select “Run”... en.kioskea.net/faq/sujet-679-restrict-change-of-background
White background's problem in web pages Your web pages will be displayed more accurately : No background color, everything is white !!! (Like this image) To resolve this problem follow these steps : 1. Go to the "Control Panel" : Click on "Option accessibility" 2. In the... en.kioskea.net/faq/sujet-60-white-background-s-problem-in-web-pages
Conditional Formatting (more than 3) in Excel Hello, i am trying to apply more than three options to excel that changes the background colour of the cell. my range is R7:R1000 i need a VBA or macro that will change the background colour of the cell as follows if cell reads "Extreme", change... en.kioskea.net/forum/affich-21716-conditional-formatting-more-than-3-in-excel

Résultats pour Conditionally changing row background color

Changing your desktop background!Changing your desktop background! Desktop background is the image or wallpaper that is being used as background on a computer screen. Wallpaper is the common terms used for designating the graphical interface in Microsoft Windows. Below... en.kioskea.net/faq/sujet-357-changing-your-desktop-background
How to insert picture background on Microsoft!How to insert picture background on Microsoft! To make a work sheet more appealing, you can add picture to your background. Below is a tip for doing so. Open your Microsoft and select “Format”> “Backgrounds” > “Printed... en.kioskea.net/faq/sujet-334-how-to-insert-picture-background-on-microsoft
Restore your Windows XP background!Restore your Windows XP background! It may happen after troubleshoot or after an unexpected error, you lost your current background due to improper shut down or computer error. To recover your windows XP background, right on your... en.kioskea.net/faq/sujet-510-restore-your-windows-xp-background

Résultats pour Conditionally changing row background color

Windows media playerHello, Having windows media player problems. My video picture is hard to see its like a watermark. It was working before installing nero I uninstalled it still cant see it. Dont know if it has to do with me not being able to change to 256 color or not... en.kioskea.net/forum/affich-4717-windows-media-player
If then statement, based on statusHello, I'm trying to find out how to do this in exel. I'm not sure if it's a macro. If entry on Column B is not "Done," and the date on Column K is equal or before Today's Date, then make the background color of that cell in Column... en.kioskea.net/forum/affich-32126-if-then-statement-based-on-status
DesktopHello, my computer was infected with spyware and i noted changed in desktop properties like change in background picture . when open window desktop properties i had three icons only instead original number icon of desktop properties in version windows... en.kioskea.net/forum/affich-11908-desktop

Résultats pour Conditionally changing row background color

Download Some PDF Image ExtractDocuments PDF can include of the text, of graphs, pictures but also pictures. Given that it is not possible to change contents, the same is true of for the extraction of a picture of the contents of the document. Some Colorful PDF Extract is a tool... en.kioskea.net/telecharger/telecharger-575-some-pdf-image-extract
Download MyColorsTopics MyColors provide a quick and efficient method to transform the appearance and the graphic interface of Windows to reflect the colors of your favorite team. Every topic is delivered with all transformations that you will have needs to change... en.kioskea.net/telecharger/telecharger-477-mycolors
Download MacIP ChangeMacIP Changes partners a very good developed program sous C ++. It is intended for the users who work in computer network LAN. MacIP Changes deal the possibility of changing fast and several times if necessary different shapes LAN, that... en.kioskea.net/telecharger/telecharger-308-macip-change

Résultats pour Conditionally changing row background color

HTML - Backgrounds A background image for a web page can be set using the tag: Attribute Visual Effect BACKGROUND="image" Displays image as background bgcolor="name_of_Colour or #XXXXXX" Displays the given colour as background LINK="Colour" Set the colour of... en.kioskea.net/html/htmlfond.php3
Spreadsheets - The Excel Interface Microsoft Excel is the spreadsheet in the Microsoft Office office suite. To start it, simply click on the appropriate icon in the Start menu (in Windows) or click on an Excel file (that has an .xls file extension). A Excel document is called a file... en.kioskea.net/tableur/tabinterface.php3
Webmastering - Webdesign The term "webdesign" refers to the discipline that consists of structuring a website's graphic elements in order to esthetically express the visual identity of a company or organisation. This is a visual design step rather than a functional design... en.kioskea.net/web/webdesign.php3