Hey,
I have two different cells containing either "OK1" or "OK2"
I would like to change a third cell into the color red if both cells ar "OK2", orange if one of the cells is"OK2" and green if both cells is "OK1".
I tried solving this problem using conditional formating, but couldn't get it to work when checking a value on a different cell. Is it possible to trig cell color using IF-sentences?
Ant tips?
Last edited by NBVC; 05-06-2011 at 03:52 PM.
Like this?
Would you like to say thanks? Please click the: "Add Reputation" button, on the grey bar below the post.
Thanksjust what I was lokking for.
btw: Is it possible to modify the formula to include the traffic icons? The color green is replaced by a green traffic lite.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks