jerichardson
Technical User
I use office 2003 here at work and I'm hitting a small road block right now. I'm trying to monitor weather or not our DVRs are recording all of their appropriate monitors and in every box I put one of the following codes:
OK
NV
Z
MU
MD
ML
MR
I'm now trying to make it so that if the cell is equal to "OK" than the background of the cell turns green, if it's "NV" than it turns red, and if it's any of the rest of them it turns yellow. Now I'm sure by that last line you've figured out my problem. Excel 2003 has a conditional formatting restriction of 3. SOOO ... does anyone know of a way for me to tie all of the rest of those into a single formula that I can enter into the conditional formatting window so that if the cell contains any of the following:
Z
MU
MD
ML
MR
It will turn to a yellow background.
Thanks!!
OK
NV
Z
MU
MD
ML
MR
I'm now trying to make it so that if the cell is equal to "OK" than the background of the cell turns green, if it's "NV" than it turns red, and if it's any of the rest of them it turns yellow. Now I'm sure by that last line you've figured out my problem. Excel 2003 has a conditional formatting restriction of 3. SOOO ... does anyone know of a way for me to tie all of the rest of those into a single formula that I can enter into the conditional formatting window so that if the cell contains any of the following:
Z
MU
MD
ML
MR
It will turn to a yellow background.
Thanks!!