Macro and Conditional formating problem. Please help!

Firstly there's no attached file!

Your conditional formatting can be done by clicking the row number (click row 3) then FORMAT>CONDITIONAL FORMATTING and enter something like this for entire row colouring =$4:$4>0 choose a colour and click ok, now when you enter a value in row 4 greater than zero the entire row will colour, if you want specific cells to colour if cells on the other row are filled then click row 1 then FORMAT>CONDITIONAL FORMATTING and enter something like this for entire row colouring =A$2>0 choose a colour and click ok, now when you enter a value in a cell in row 2 the cell above will conditional format.


Google Me
Find me located here Simon Lloyd and what i'm about Here
The above is NOT a link to a forum so is NOT against Rule 13

Hello Simon:

For the cell formatting, I am setting each row at a time and it's take too long. I tried to highlight the column C and then format/conditional format, enter =$B:$B>90, select blue. The entire column C turns blue instead only the one with score >90. Please help! I am just a dummy!

Best regards,
Kim A

In your file your data is laid out wrong to manipulate it properly, what you want to acheive can all be done with VlookUp, you need to lay out the data in one row or have one row per exam....etc then life would be a lot easier


Google Me
Find me located here Simon Lloyd and what i'm about Here
The above is NOT a link to a forum so is NOT against Rule 13

Hello Simon:

Thank so much for your quick response! I am working on the formatting now. For the test data, that is how they come in not in order. I guess they log in as the student come in taking test. The Progress page was done by sorting out by student name and then I added the Student. I try to find a quick way to have this done. Your advise is greatly appreciated!

Kim A

On your student progress sheet you should have one line for every exam of each student, so it may result in seeing hundreds of names in column A and many of them repeated but then you can filetr for them


Google Me
Find me located here Simon Lloyd and what i'm about Here
The above is NOT a link to a forum so is NOT against Rule 13

Again, thank so much for your help!

Thanks, Rory! It works!

May I ask for you rhelp again?

I tried to set = $B1 between 75 and 91 and = $B1 >75 and <91, but it does not work. Please help.

Best regards,
KimA

Originally Posted by OnErrorGoto0

You need
=and($B1>75,$B1<90)

Thank so much for your help!

Best regards,
KimA