Excel VBA Course
Excel VBA Course - From Beginner to Expert

200+ Video Lessons
50+ Hours of Video
200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course

how to highlight values in cells automatically

0

hi my question is

1) In an internal examination we have 8 questions and marks for each question is 5, which will be 40 marks.

2) the student has to answer 5 questions which will lead to 25 marks, but some students answer more than 5 and i have written the formula to consider only 5 questions and the formula is "SUMPRODUCT(LARGE((F9:M9>=0)*F9:M9,{1,2,3,4,5}))"

3) my question is from F9 to M9 only those questions(i.e cells)  which have higher marks has to be highlighted with a colour automatically . how to do this

plz reply 

excel
MS Office Version: 2007
posted by: manjukb on Thu May 11, 2017 at 12:18 am
Answer
Discuss

Discussion

i need complet data so that i provide output
shirish Oct 5, '17 at 4:42 am
Add to Discussion

Answers

0

you could use Conditional formatting for values either  Greater than 5   OR Greater than or Equal to 5.

posted by: queue (rep: 467) on Fri May 12, 2017 at 10:09 am
Discuss
0

You can use a custom conditional format and use this formula:

=IF(RANK(G1,$G$1:$G$10,0)<=5,TRUE,FALSE)

This assumes that your numbers are in cell G1:G10. Make sure to keep the dollar signs in there for the range and then apply this forumula to the entire range where you want to have conditional formatting.

If you need more of an explanation, just let me know.

posted by: don (rep: 1989) on Mon May 15, 2017 at 7:35 am
Discuss


Answer the Question

You must create an account to use the forum. Create an Account or Login