Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Conditional Formatting - Color row based on one cell value
I need to color code a row (10 columns) based on the value in column a being
a specific job name or number (8 to choose from). Conditional formatting only allowed 3 conditions and only worked on individual cells. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Conditional Formatting - Color row based on one cell value
For more than 3 formats I use somthing like:
Private Sub Worksheet_SelectionChange(ByVal Target As Range) Select Case Cells(1.1).Value Case 1 Range("A1:J1").Interior.ColorIndex = 35 Range("A1:J1").Font.Bold = False Case "Gerard" Range("A1:J1").Interior.Color = RGB(255, 0, 0) Range("A1:J1").Font.Bold = True Case Else Range("A1:J1").Interior.Color = RGB(255, 255, 255) Range("A1:J1").Font.Bold = False End Select End Sub -- Groeten / Greetings, Gerard "Monica" wrote: I need to color code a row (10 columns) based on the value in column a being a specific job name or number (8 to choose from). Conditional formatting only allowed 3 conditions and only worked on individual cells. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditional Formatting using color based on another cell | Excel Discussion (Misc queries) | |||
Conditional Formatting based in cell color | Excel Discussion (Misc queries) | |||
Conditional Formatting (Excel 2007) Format Row Color Based on X | Excel Discussion (Misc queries) | |||
Find cells w/background color based on conditional formatting | Excel Worksheet Functions | |||
Change Font Color Based on Conditional Formatting | Excel Worksheet Functions |