maximus4004
New Member
- Joined
- Jun 2, 2011
- Messages
- 5
I am using a VLOOKUP function to get minimum and maximum values. With a conditional formating rule, I want to use the 3-color scale (Format all cells based on their values). In my minimun I choose type "Formula" for my minimum and Maximum. But went I insert my VLOOKUP formula, it does not want to use it.
="VLOOKUP([@Column1],'Lamps hours Data Projector'!$A$2:$E$42,4)" (excel gave me a error message or he put " at the on the formula.)
The idea is to see in colors when we need to change the lamp on projectors. But the projectors are not using the same MAXIMUM values(hours)
Max
Example
Projector PLC-XU60 min hrs 0, maximum hours 2000 hrs (standard mode)
Projector PLC-XT11 min hrs 0, maximum hours 1500 hrs (standard mode)
Projector PLC-5500 min hs 0, maximum hours 2000 hrs normal, 2500 hrs standard, 3000hrs ecomode
="VLOOKUP([@Column1],'Lamps hours Data Projector'!$A$2:$E$42,4)" (excel gave me a error message or he put " at the on the formula.)
The idea is to see in colors when we need to change the lamp on projectors. But the projectors are not using the same MAXIMUM values(hours)
Max
Example
Projector PLC-XU60 min hrs 0, maximum hours 2000 hrs (standard mode)
Projector PLC-XT11 min hrs 0, maximum hours 1500 hrs (standard mode)
Projector PLC-5500 min hs 0, maximum hours 2000 hrs normal, 2500 hrs standard, 3000hrs ecomode
