Conditional formatting help

Solved/Closed
tinayat Posts 2 Registration date Thursday January 16, 2014 Status Member Last seen September 30, 2014 - Jan 16, 2014 at 09:35 AM
tinayat Posts 2 Registration date Thursday January 16, 2014 Status Member Last seen September 30, 2014 - Jan 16, 2014 at 01:15 PM
Hi,

I have a spreadsheet with a column for employee hours. Anything over 9 hours is considered overtime and we are tracking how many employees are working overtime on a daily basis so I conditionally formatted those cells with the following formula

=AND(B3>9)=TRUE

If a value over 9 is entered then the cell turns red indicating overtime.

Now my problem is, some employees may be working that day but for a different department so we would put N/A or whatever else in the cell instead of a number. When I do that the cell still turns red. Can someone please tell me how to fix this?

2 responses

TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 555
Jan 16, 2014 at 10:59 AM
Hi Tinayat,

Try the following formula:
=AND(B3>9,ISNUMBER(B3)=TRUE)

Best regards,
Trowa
1
tinayat Posts 2 Registration date Thursday January 16, 2014 Status Member Last seen September 30, 2014
Jan 16, 2014 at 01:15 PM
Thank you very much for your help :)
0