TAPS_MikeDion
Well-known Member
- Joined
- Aug 14, 2009
- Messages
- 622
- Office Version
- 2011
- Platform
- MacOS
My apologies for my brain being a bowl of pudding right now. Hopefully this question doesn't come across too stupid to ask, but...
All I'm looking to do is to use conditional formatting for a group of cells to change the text color to red if the value in any given cell is =>1. However, there will be cases when an X is present in the cell, which is throwing off my results. Right now anything in a cell formats the color to red. As I was typing this out I was thinking that I may need an ISNUMBER formula to do this?
Thank you for your help!
-Mike
All I'm looking to do is to use conditional formatting for a group of cells to change the text color to red if the value in any given cell is =>1. However, there will be cases when an X is present in the cell, which is throwing off my results. Right now anything in a cell formats the color to red. As I was typing this out I was thinking that I may need an ISNUMBER formula to do this?
Thank you for your help!
-Mike