Make a cell font red if number is greater than 200
You can use conditional formatting on the cell to make it turn red if
the cell contents exceed 200. Also, you could use another cell to
produce the error message, like this:
=IF(A1200,"Excess Hours","")
Format that cell with bold and in red if you like.
Hope this helps.
Pete
On Oct 6, 3:23*pm, delete automatically
wrote:
Make a cell font red if number is greater than 200 and have a message pop up
saying (you have exceeded the number of hours allowed).
|