Put your mouse at Highlight Cell Rules, a drop down box appears.ġ1. Now to apply conditional formatting, click again on cell C3 and go to Conditional Formatting under Home tab. The Pass word is shown because the student scored more than 40% grades.Ĩ.In order to apply this function to all cells till end, click on the cell C3 again then click the right corner of the cell, drag vertically till B28.ĩ. This is the full condition which means that if the value is less than 40, type fail, otherwise pass.ħ. Again type comma, and then write Pass in inverted commas. Now type comma, and then write Fail in inverted commas like this “Fail”Ħ. This is the 1 st part of condition telling if the cell value is less than 40.ĥ. Now go to cell B3, click it and type < (less than) then type 40. Then press Enter, the IF statement is activatedĤ. Now type equals sign and if in this cell. Use the IF statement before applying colors. If we need to find fail students without wasting time, use conditional formatting.Ģ. In this data many students passed while few failed. Here is an example of test grades of students in terms of percentage. Note: There is only one way to access conditional formatting as belowġ.
Excel formula for row color how to#
If you are wondering how to fill color in excel cell using formula, here is your guide to it. In order to specify the condition, you can use IF statement and then use conditional formatting to highlight the conditions. Additionally, specification of important information gets easy. When you use colors in your excel worksheets you can instantly visualize the difference or comparison in value. How to fill color in excel cell using formula? You can do this by conditional formatting option.