| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Iserror change cell color
I am trying to change the cell color when I get an error. Here is th vlookup I am using. I want to change to red when I get Not Assigne Yet. Please help. =IF(ISERROR(VLOOKUP($G12,'SAS Specialis Assigned'!$D$4:$E$1288,2,0)),"Not Assigned Yet",VLOOKUP($G12,'SA Specialist Assigned'!$D$4:$E$1288,2,0) -- geparksj ----------------------------------------------------------------------- geparksjr's Profile: http://www.excelforum.com/member.php...fo&userid=2567 View this thread: http://www.excelforum.com/showthread.php?threadid=39336 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Iserror change cell color
Select the cell, then in the menu
format=conditional formatting In conditional formatting set the condition to Cell Value is "Not Assigned Yet" -- Regards, Tom Ogilvy "geparksjr" wrote in message ... I am trying to change the cell color when I get an error. Here is the vlookup I am using. I want to change to red when I get Not Assigned Yet. Please help. =IF(ISERROR(VLOOKUP($G12,'SAS Specialist Assigned'!$D$4:$E$1288,2,0)),"Not Assigned Yet",VLOOKUP($G12,'SAS Specialist Assigned'!$D$4:$E$1288,2,0)) -- geparksjr ------------------------------------------------------------------------ geparksjr's Profile: http://www.excelforum.com/member.php...o&userid=25677 View this thread: http://www.excelforum.com/showthread...hreadid=393367 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Iserror change cell color
Take a look at conditional formatting, set up using the Format-Conditional
Formatting or using VBA with With Range("A1:A20") ' change range as required .FormatConditions.Delete .FormatConditions.Add Type:=xlCellValue, Operator:=xlEqual, _ Formula1:="=""Not Assigned Yet""" .FormatConditions(1).Font.ColorIndex = 3 End With -- Cheers Nigel "geparksjr" wrote in message ... I am trying to change the cell color when I get an error. Here is the vlookup I am using. I want to change to red when I get Not Assigned Yet. Please help. =IF(ISERROR(VLOOKUP($G12,'SAS Specialist Assigned'!$D$4:$E$1288,2,0)),"Not Assigned Yet",VLOOKUP($G12,'SAS Specialist Assigned'!$D$4:$E$1288,2,0)) -- geparksjr ------------------------------------------------------------------------ geparksjr's Profile: http://www.excelforum.com/member.php...o&userid=25677 View this thread: http://www.excelforum.com/showthread...hreadid=393367 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Iserror change cell color
Use conditional formatting on the cell with a formula of
=ISERROR(cell_address) -- HTH RP (remove nothere from the email address if mailing direct) "geparksjr" wrote in message ... I am trying to change the cell color when I get an error. Here is the vlookup I am using. I want to change to red when I get Not Assigned Yet. Please help. =IF(ISERROR(VLOOKUP($G12,'SAS Specialist Assigned'!$D$4:$E$1288,2,0)),"Not Assigned Yet",VLOOKUP($G12,'SAS Specialist Assigned'!$D$4:$E$1288,2,0)) -- geparksjr ------------------------------------------------------------------------ geparksjr's Profile: http://www.excelforum.com/member.php...o&userid=25677 View this thread: http://www.excelforum.com/showthread...hreadid=393367 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Cannot change font color or cell color | Excel Discussion (Misc queries) | |||
| Change tab color based on current color of a cell | Excel Discussion (Misc queries) | |||
| Excel: Syntax to change cell color based on color of another cell | Excel Worksheet Functions | |||
| How to change the default Border, Font Color, and Cell Color | Excel Discussion (Misc queries) | |||
| Browse Forms Controls and change TextBox color based on cell color | Excel Programming | |||
Linear Mode
