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 :
Background color of cell in Excel Show
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...
Conditional Formatting (more than 3) in Excel Show
Changing the background image of Grub ShowChanging 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...
[VBA] Detecting changes in cell Show[VBA] Detecting changes in cell The Event Change feature of a sheet will detects the change in the active cell but it gives no information about the content. The example given below will help you to find out if the cell was changed,...
Download Caledos Automatic Wallpaper Changer ShowCaledos Automatic Wallpaper Changer, as its name indicates, is a screen background administrator. The main features of Caledos : - it supports the image formats BMP, GIF, JPG, TIF, - easy selection of files or folders, - the possibility of...
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...
Download Background Boss Show
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...
Spreadsheets - Conditional expressions ShowWhat is a Conditional Structure? Conditional structures are instructions that allow to test if a condition is true or not. Conditional structures may be associated together. To successfully execute these tests using logical functions, spreadsheets...
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
  • +3

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
  • +25

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