Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Conditional formatting help required please
I have a spreadsheet where cell C& requires the user to enter either "Y" or "N". Depending which they enter I need to recolour cells B7:B12. I have completely run out of ideas for how to do this - Excel bible, web searches etc. have not solved the problem. Can someone please please put me out of my misery - I know it can be done and I'm sure its simple (when you know how)? Many thanks Tony (now you know why I log in backwards ... ynoT !!!) -- y_not ------------------------------------------------------------------------ y_not's Profile: http://www.excelforum.com/member.php...o&userid=19947 View this thread: http://www.excelforum.com/showthread...hreadid=389006 |
#2
|
|||
|
|||
If there are 3 or loess values, you can use conditional formatting -
FormatConditional Formatting... Select the cell, invoke CF, and enter your first value, click Format and set the colour. For more conditions, click the Add. If you have more than 3 conditions, use worksheet events Private Sub Worksheet_Change(ByVal Target As Range) On Error GoTo ws_exit: Application.EnableEvents = False With Target If .Address = "$C$10" Then Select Case .Value Case 1: .Interior.ColorIndex = 3 Case 2: .Interior.ColorIndex = 5 Case 3: .Interior.ColorIndex = 6 Case 4: .Interior.ColorIndex = 10 'etc End Select End If End With ws_exit: Application.EnableEvents = True End Sub 'This is worksheet event code, which means that it needs to be 'placed in the appropriate worksheet code module, not a standard 'code module. To do this, right-click on the sheet tab, select 'the View Code option from the menu, and paste the code in. -- HTH RP (remove nothere from the email address if mailing direct) "y_not" wrote in message ... I have a spreadsheet where cell C& requires the user to enter either "Y" or "N". Depending which they enter I need to recolour cells B7:B12. I have completely run out of ideas for how to do this - Excel bible, web searches etc. have not solved the problem. Can someone please please put me out of my misery - I know it can be done and I'm sure its simple (when you know how)? Many thanks Tony (now you know why I log in backwards ... ynoT !!!) -- y_not ------------------------------------------------------------------------ y_not's Profile: http://www.excelforum.com/member.php...o&userid=19947 View this thread: http://www.excelforum.com/showthread...hreadid=389006 |
#3
|
|||
|
|||
for cells B7 to B12, set the conditional format to something like ... Condition 1. Formula. =if(C7="Y",1,0) Then set the colours accordingly. Condition 2. Formula. =if(C7="N",1,0) Then set the colours accordingly. Hope I've understood correctly and this helps. -- tonywig ------------------------------------------------------------------------ tonywig's Profile: http://www.excelforum.com/member.php...o&userid=18985 View this thread: http://www.excelforum.com/showthread...hreadid=389006 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditional Formatting Error | Excel Worksheet Functions | |||
difficulty with conditional formatting | Excel Discussion (Misc queries) | |||
conditional formatting question | Excel Discussion (Misc queries) | |||
Determine cells that drive conditional formatting? | Excel Discussion (Misc queries) | |||
Conditional formatting not available in Excel | Excel Discussion (Misc queries) |