highlight specific range based on words in multiple sheets

hello
i need help to highlight range from a: j if value in any cell this range "done" then color by red and if value in any cell this range "ok" then color by blue in all of sheets i know i can this with condition formatting but it takes long time if i have huge numbers of sheets i would this by code to do that very quick

thanks , Karmapala not exactly i would highlight the row from a: j if contains the words not only cell contains the word

Please have a look the corrected code on post #2, Abdelfatta.
The code now will highlight the row from A to J if any of row within A to J has "done" or "ok".
This assumes that there won't be "done" and "ok" in the same row within A to J.
If there is a situation like that, then this row will have blue color.

yes you'r right i no know what's wrong in the beginning it just highlight cells contains the words thank so much that what i want

hi, Karmapala is there way to do the row no color if i clear theses words done or ok

it gives me this error

Originally Posted by ABDELFATTA

it gives me this error

Strange.

In my side, it didn't give me any error.

2020-06-06_14-17-54.gif

Please try to step-run the macro (hit F8),
then please tell me on what line it gives you the error.

the error in this line

hi, karmapala you are right it's mystery do me favor ,please can you add line code in post 2# to make the row no color if i clear words done or ok , it supposes to clear the row what contains the word

Originally Posted by ABDELFATTA

hi, karmapala you are right it's mystery do me favor ,
please can you add line code in post 2# to make the row no color
if i clear words done or ok

Abdelfatta,
The sub in post #2 is not to automatically :
1. highlight row n column A to J, when user type "done" or "ok" in row n of any column within A to J.
2. clear the highlight row n column A to J, when user clear the word "done" or "ok" in row n of any column within A to J.

Below is the sub in post #2 added with one new line

Please Login or Register  to view this content.

Please remember that the user still need to click the button, Abdelfatta.

yes, this is what i want don't worry about automatically i make it in this change

HTML Code: 

it colors when i write and clear when i clear the word the code in post 7# it doesn't work for me i no know why that's why i asked for you adjusting the code i try finding way to solve the problem about code in post #7 if i got it i will inform you now the code is complete thanks so much for everything