Conditional formatting help

Solved/Closed
tinayat
Posts
3
Registration date
Thursday January 16, 2014
Status
Member
Last seen
September 30, 2014
- Jan 16, 2014 at 09:35 AM
tinayat
Posts
3
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 replies

TrowaD
Posts
2880
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
May 2, 2022
510
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
3
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