Search : in
By :

Conditionally changing row background color

Last answer on Dec 5, 2008 3:27:07 pm GMT PowerBuilder, on Oct 2, 2008 12:31:30 am BST 
 Report this message to moderators

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

Best answers for « Conditionally changing row background color » in :
Restrict change of background Show 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 Then type...
Background color of cell in Excel Show
Changing the background image of Grub Show Changing the background image of Grub To change the background image for Grub, which is in the archive /boot/gfxmenu, simply replace it with another image of the same size and same name, Defaultly named(800*600, back.jpg...
White background's problem in web pages ShowYour 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...
[Outlook Express] Create letter paper / Insert background image Show[Outlook Express] Create letter paper / Insert background image The letter paper is an Outlook Express feature allowing sending emails with illustrations (images, text, etc.) as background. Creating letterhead under Outlook Express In the...
Changing your desktop background! ShowChanging 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...
Download Color Picker 1.51 Show
Download Background Boss Show
Download WorldTimer ShowWorldTimer is a custom worldwide clock which can show a certain some number of of clocks in different time zones. It is also possible to change the face of the clock and time zone for each clock, the background color, as well as the text color as...
Managing images in HTML ShowHow do you display images on a web page? Having a few images on a website can make it more attractive and user-friendly. However, it is important not to go overboard, since images can take a long time to load, and in some cases can make a document...
Backgrounds ShowAdding a Background Image 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...
CSS - Style sheets ShowFont properties Property Value Description font-family Specific font (Arial, Times, Verdana) Familly (serif, sans-serif, fantasy, monospace, cursive) Defines one or more font names or font families. If multiple fonts are defined,...
Ask your question Reply

1

voicesms, on Oct 2, 2008 9:41:47 am BST

Hello,

cant you get that option in the properties of the datasheet?

   
Reply to voicesms

2

BALU, on Oct 31, 2008 9:31:48 am GMT

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

3

Thinker3, on Dec 3, 2008 2:20:05 pm GMT
  • +8

Conditional Formatting is limited to 3 analysis (must return true/false result), or 4 if you count no analysis, and will not return the desire result.

   
Reply to Thinker3

4

Raju, on Dec 5, 2008 7:43:07 am GMT
  • +2

ORng = oSheet.get_Range("A1", "BZ1");
oRng.Interior.Color = System.Drawing.ColorTranslator.ToOle(System.Drawing.Color.Silver);

   
Reply to Raju

5

 PowerBuilder, on Dec 5, 2008 3:27:07 pm GMT
  • +24

Thanks for the response,Raju. But where would I code those 2 lines that you have suggested. It would be great if you can briefly explain what it does exactly

   
Reply to PowerBuilder
Ask your question Reply
They need your help