-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
compare two cells
-
K
return a value of '1' if the lowest value amoung the two cell is green
Please do you know how to formulate the following condition in excel; when you have two cells one with high and the other with low value and one of the cell is colored green. so you want to return a value of '1' if the lowest value amoung the two cell is green color and '0' is the highest value...- kingsy18
- Thread
- color to value compare two cells condition in excel two arguements visual basic help
- Replies: 1
- Forum: Excel Questions
-
A
conditional format compare two cells
Hi I am really struggling with a conditional format and have tried ABS and not equal to. What I am looking to do is compare two cells trying to compare cell T3 with T4 and if they are = to each other then fine and if the variance is less/greater that 1.0 then cell turns orange for instance...- abb16ott
- Thread
- compare two cells
- Replies: 5
- Forum: Excel Questions
-
G
Compare key value in two sheets and update hours.
Hi Guys I want to compare 2 values using keyfield(TaskNo) and update hours column in Sheet2. if the search key not found in sheet2 add to last record in sheet2. example Sheet 1 ---------------- A B B 1 TaskNo Hours 2 4575 10 3 8545 20 4 7854 5 Sheet 2 ---------------- A B B 1 TaskNo Hours...- Gane27
- Thread
- compare two cells macro vba vlookup with range
- Replies: 0
- Forum: Excel Questions
