Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Logic Programming
I have a workbook comprised of several worksheets. All of the worksheets
lookup data from a single worksheet using the VLOOKUP function. How do I code an IF THEN statement that will highlight a cell Red if it returns a certain value and leaves the cell White if any other value is returned? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Logic Programming
Hi,
The formula itself can't change the format of the cell, but you can use Conditional Formatting to accomplish that: Needs Sage Advice wrote: I have a workbook comprised of several worksheets. All of the worksheets lookup data from a single worksheet using the VLOOKUP function. How do I code an IF THEN statement that will highlight a cell Red if it returns a certain value and leaves the cell White if any other value is returned? http://www.contextures.com/xlCondFormat01.html -- Regards, Jake Marx MS MVP - Excel www.longhead.com [please keep replies in the newsgroup - email address unmonitored] |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2007-macro programming logic for data validation | Excel Discussion (Misc queries) | |||
More if then logic | Excel Worksheet Functions | |||
More if then logic | Excel Worksheet Functions | |||
LOGIC | Excel Discussion (Misc queries) | |||
Programming Logic | Excel Programming |