Hi there! I use conditional formatting all the time, and I can't for the life of me figure out why some of my values are being ignored. I've tried Text to Columns, I've tried reformatting the cells, I've double checked the cells from which these cells are pulling data.....can't figure it out! Can ya help a sister out??
"Compiled" tab.
Thank you!!
In columns H,I there are strings, not numbers
Last edited by tim201110; 01-27-2017 at 02:27 PM.
Hi! I'm confused by your response - there's nothing in column J. Sorry if I was unclear - the problem columns are H and I. I just tried what you suggested and it gave me the "#VALUE!" error.In columns J,I thereare strings, not numbers
='6'!C5*1, in this case it works
Hello lbickford sis : In sheet "6" & "7" (from "C5" to "C10") there are as string, in those cells i enter value manually once again & format as "General"
I have attach revised your file. Plz look. Hope your prob resolved.
atul
If my answer (or that of other members) has helped you, please say "Thanks" by clicking the Add Reputation button at the foot of one of their posts.
Also: if your problem is solved, please take the time to mark your thread as SOLVED by going to the top of your first post, selecting "Thread Tools" and then "Mark thread as solved".
There is CHAR(160) as a leading character for the values in column C on worksheets 6 and 7. Using Alt+0160 in Find field in Find and Replace might work with your computer to replace the space...leave the Replace With blank. Replace All.
If that doesn't work, select the non-breaking space in front of the number, copy and paste that into the Find field leaving the Replace with blank...replace all.
With the above taken care of on worksheets 6 and 7 your Conditional formatting works fine.
<---------If you like someone's answer, click the star to the left of one of their posts to give them a reputation point for that answer.Ron W
yes in sheet "6" & "7" their is a space before number.
You can do also with =Trim function
Last edited by avk; 01-27-2017 at 04:44 PM. Reason: Addition
All solved!! Thanks so much for the help!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks