Conditional Formatting

[rvvan]

Hello,

I have a chart in sheet 4 (E2:AJ18) that is a list of tote numbers. In sheet 1 I am "adding a tote" to the system and want it to find the tote that was entered in sheet 1 (A:2) and highlight it Red in the chart. and then in sheet 14, after any cell in column J is populated with "printing" I need it to find the tote # in column H and highlight it Green in the chart, and also delete the entire row in sheet 14. Is this possible? Any help would be GREAT!

 

[Fishboy]

This is exactly what I needed. Thanks a bunch sir!!

Happy to help mate

Not sure how to input a screenshot, but anyreason why it would be giving me a runtime error 9 message ut of range? It works on the excel file you made, but it seems to not like my sheet numbers...

Hmm, that suggests that the sheet names / numbers do not match those in the code. You will need to double-check them all to make sure they are exactly as they are in the code and change either the sheet names or the names referenced in the code so everything matches up.