Hi
I am trying to change the colour of cells based on the values of 2 other cells but I couldn't get the right VBA code for Excel 2003. Could you please help me with the following conditions:
if valueX<=2 and valueY<=2, green colour
if valueX>=4 and valueY>=4, red colour
otherwise, yellow colour.
There might be more similar conditions, therefore I want to use VB to handle...
tiwariprakash
Last Activity: Aug 13 '09, 02:46 PM
Joined: Jul 25 '07
Location:
-
Conditional Fomatting (>3 conditions)
-
Thank you very much for your views.
prakash -
Alternatively, I am wondering, whether somebody has an idea to change following table with unique fields.
ID Weight
1 22
1 33
2 22
2 33
3 44
4 55
4 66
4 77
5 55
5 66
5 77
6 55
6 66
6 77
Can we convert as:
ID Weight
1 22
2 33
3 44
4 55
5 66
6 77
Your views...Leave a comment:
-
Thanks for the reply. However, I am not able to link ID and Weight because both or them are unique and don't have any other field to link.
Prakash...Leave a comment:
-
Thank you for your reply.
Please find 2 tables which need to be combine based on the Item.
Table 1:
ID Item
1 Mixer
2 Mixer
3 Pump
4 Valve
5 Valve
6 Valve
Table 2:
Item Weight
Mixer 22
Mixer 33
Pump 44
Valve 55
Valve 66
Valve 77
Mixer (ID=1) grab the...Leave a comment:
-
MS Access Duplicates
Hello
I am having problem with duplicates. I have two table as below:
ID Item Name
1 Mixer
2 Mixer
Item Name Weight
Mixer 33
Mixer 22
ID Item Name Weight
1 Mixer 33
1 Mixer 22
2 Mixer ...
No activity results to display
Leave a comment: