Previous Topic Next Topic

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

Answer 1 / 2
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
Answer 2 / 2
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 :)

Similar discussions

Highlight cell if another cell contains specific text
Abbi -
vcoolio -

Hello,

I have random text in cell C6 that I would like to highlight green if cell N6 has 'yes', red if cell N6 has 'no', and grey out if cell N6 has 'n/a'. Any suggestions for which formula to use?

Any help would be greatly appreciated!

1 response
How to use conditional format based on text?
Leanne99 -
Mooseman -

Hello,

I want a cell to change color if another cell contains the words "first aid". The text comes down from a drop down list and could read "First Aid" or "sleepover/first aid".

If the cell has "first aid" in it, I want the other cell to change color. I can get it to work if using formula f13=first aid but it won't change color if the cell says sleepover/first aid?

Can anyone help?

26 responses
What shall i do after formatting my laptop?
upen91 -
jack4rall -

Nowadays there are a lot of websites are having tutorials for how to format our laptop in step by step. But no one shows or tells that what we need to do after format our laptop like what are the basic things such as drivers and software's that should be install importantly. So please tell me what are the things that we need to do after formatted our laptop. My laptop is Acer Aspire 4540 and OS is Windows7. Thank You.

1 response