Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Conditional Formatting
Hello, I was hoping to use conditional formatting to make a vlookup function that returns an #N/A turn red. Thanks -- Gbonda ------------------------------------------------------------------------ Gbonda's Profile: http://www.excelforum.com/member.php...fo&userid=8758 View this thread: http://www.excelforum.com/showthread...hreadid=398687 |
#2
|
|||
|
|||
Select the cell you want to appy the Conditional Formatting to and click FormatConditional Formatting... for Condition 1 select Formula Is: and enter this: =ISNA($A$1) Click Format and pick your color on the Font tab (or fill color from the Patterns tab) and click OK twice... Of course adjust the cell reference $A$1 to meet your needs... Does that work for you? Bruce -- swatsp0p ------------------------------------------------------------------------ swatsp0p's Profile: http://www.excelforum.com/member.php...o&userid=15101 View this thread: http://www.excelforum.com/showthread...hreadid=398687 |
#3
|
|||
|
|||
No it is not working. Any other ideas? -- Gbonda ------------------------------------------------------------------------ Gbonda's Profile: http://www.excelforum.com/member.php...fo&userid=8758 View this thread: http://www.excelforum.com/showthread...hreadid=398687 |
#4
|
|||
|
|||
Trust me, if you followed my instructions, it WILL work. Are you sure your cell is returning a true #N/A result? Did you adjust the cell reference from $A$1 to the cell that has the VLOOKUP FORMULA? What is your VLOOKUP formula? Are you applying the CF to the cell with the VLOOKUP formula? More details, please. -- swatsp0p ------------------------------------------------------------------------ swatsp0p's Profile: http://www.excelforum.com/member.php...o&userid=15101 View this thread: http://www.excelforum.com/showthread...hreadid=398687 |
#5
|
|||
|
|||
I stand corrected. Worked like a charm. Thanks for all your help. -- Gbonda ------------------------------------------------------------------------ Gbonda's Profile: http://www.excelforum.com/member.php...fo&userid=8758 View this thread: http://www.excelforum.com/showthread...hreadid=398687 |
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) |