Previous Topic Next Topic

Help please (Excel)

Closed
Ren - Aug 26, 2008 at 02:37 AM
 Ren - Aug 26, 2008 at 05:32 AM
Hello,

I have a excel sheet that is really tricky.

This is a bit a my problem.

Lets say it's a test. I have a Total Amount Scored column and a TOTAL (this is the total for the paper.)

I created a new column to show me the % of the paper. This has conditional formatting on it. Works just fine.

Now my problem is:

Let's say the guy has 15 points out of 60. This will be 25%. This part is fine.

But in the column where you see his total amount scored (which is 15) it has to flag you red, yellow or green (like the percentage.)

How can I just copy the fill color of the percentage cell. I'll convert it back to his original points.

Thanks guys,

Ren
Related:

2 responses

Answer 1 / 2
vpnserver Posts 14 Registration date Tuesday August 19, 2008 Status Member Last seen February 22, 2009 1
Aug 26, 2008 at 05:13 AM
yes i think you can do that but if its not good then try to see in the help file there must be something for your problem

see you
0
Answer 2 / 2
Ren
Aug 26, 2008 at 05:32 AM
Cool man but I got it working.

This is the code I used:



If Range("I27").Value <= 40 Then
Range("F27").Interior.ColorIndex = 3

Else

If Range("I27").Value > 40 Then
If Range("I27").Value < 80 Then
Range("F27").Interior.ColorIndex = 6

Else

If Range("I27").Value >= 80 Then
Range("F27").Interior.ColorIndex = 4

End If
End If
End If
End If








Not to bad for a Novice vba coder, hehe.... Working like a charm...
0

Similar discussions

Date formatting in dd/mm/yyyy
nisha -
appu -

11 responses
How to calculate positions (1st,2nd,3rd...) in Excel
hardy -
TrowaD -

6 responses