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

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

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

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