I need to change the color of a row in the details if a certain field contains a certain text. Ex: field status =shipped so make the row green, status = packed make the row red etc. conditional formatting will only change the one field. If anyone has any ideas let me know