ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Need conditional statement to paint a cell (https://www.excelbanter.com/excel-discussion-misc-queries/91451-re-need-conditional-statement-paint-cell.html)

Jim Thomlinson

Need conditional statement to paint a cell
 
You can use conditiona formatting. Select the area where the grades are
entered and then select Foramt - Conditional Formatting. Change the cirteria
to less than and then enter the value...
--
HTH...

Jim Thomlinson


"M.L." wrote:

I'd like to embellish my gradebook by automatically painting cells a
specific color when the grade entered is less than 70. Any help will
be greatly appreciated. Thanks.



All times are GMT +1. The time now is 12:07 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com