DIGIT-ARC read-only archive · snapshot: July 23, 2026

DIGIT-ARC / Software / Software Q&A

MS Excell

3 posts · originally from https://geek.digit.in/community/threads/ms-excell.67606/

skghosh44
skghosh44 Original post #1
Sep 7, 2007 at 10:28 PM
=IF(I5>=60,"1st Division",IF(AND(I5>=45,I5<60),"2nd Division","Fail"))
Click to expand...
Pl go through this excell formula. It is a formula to find out the grade as 1st Division, 2nd Division and Fail out of toal marks. Now I wish to display the "Fail" remarks in RED color. How can I do it?
P
pillainp #2
Sep 7, 2007 at 11:00 PM
Simplest way would be to use conditional formatting. Set the value of the cell to "Fail" and then adjust for the necessary formatting.
skghosh44
skghosh44 #3
Sep 8, 2007 at 10:20 PM
Thanks for the answer, Now I am able to do the job.