im asking you how i do that.
if i knew how to do that this thread would have been pointless
i need to know how to set up the condition
and id like it to be on the same page so its easier to find instead of click on 3 different sheets
say i enter something like this
543 blahblah no go = highlighted in red when the word no is entered
324 blah bla ok = red upon entering ok
342 eurewurwe pending = yellow upon entering pending or another word i choose
thats what i am looking to do all on the same sheet