| Home |
| Search |
| Today's Posts |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
VLookup & Conditional Formatting together
Hi,
If I understand correctly, Vlookup() provides you with the answer ... i.e. Yes or No ... which does not interfere with conditional formatting as such ... With your cursor on the cell to be formatted ... Format Conditional Formatting Cell Value is equal to ="Yes" Format Patterns Green and then add new condition for ="No" in red ... HTH |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| vlookup with conditional formatting | Excel Worksheet Functions | |||
| VLookup for Conditional Formatting | Excel Discussion (Misc queries) | |||
| Conditional formatting formula that uses VLookup, based on content of another cell | Excel Discussion (Misc queries) | |||
| Conditional formatting on cells with a VLOOKUP formula in them | Excel Discussion (Misc queries) | |||
| vlookup & conditional formatting | Excel Worksheet Functions | |||
![Carim[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
