Conditional formatting help [Solved/Closed]

Report
Posts
3
Registration date
Thursday January 16, 2014
Status
Member
Last seen
September 30, 2014
-
Posts
3
Registration date
Thursday January 16, 2014
Status
Member
Last seen
September 30, 2014
-
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

Posts
2670
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
October 22, 2020
446
Hi Tinayat,

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

Best regards,
Trowa
1
Thank you

A few words of thanks would be greatly appreciated. Add comment

CCM 2942 users have said thank you to us this month

Posts
3
Registration date
Thursday January 16, 2014
Status
Member
Last seen
September 30, 2014

Thank you very much for your help :)