| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Conditional Format / VLookup
What I would like to do is have a conditional format which looks at the
value of the cell then find the matching value on the WorkShifts Monday worksheet (that value would be found in column A and then when it finds that look at Column U. If the value in column U is "Large" I want to set the cell shading to blue ( I know how to set the format if the condition is met it is everything before that I can not figure out). The range for WorkShifts Monday worksheet is A3:U120. I am assuming that this would require there to be some sort of VLookUp as part of the conditional forma. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| VLOOKUP in conditional format? | Excel Discussion (Misc queries) | |||
| Conditional Format w/ vlookup???? | Excel Discussion (Misc queries) | |||
| Conditional Format overwrighting previous conditional format | Excel Programming | |||
| conditional format on cells using VLOOKUP | Excel Discussion (Misc queries) | |||
| VLOOKUP in a conditional format | Excel Discussion (Misc queries) | |||
Threaded Mode
