LinkBack URL
About LinkBacks
In range A1:D10, check length of cell and, if length of any cell is grater then 3, then fill that cells color RED
In range A1:D10, check length of cell and, if length of any cell is grater then 3, then fill that cells color RED
Last edited by ionelz; 01-20-2019 at 12:01 PM.
So the cells that need to be red are the cells in the range A1:D10?
Try this with A1 selected:
=LEN(A1)>3
The applies to range should be A1:D10
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help. It's a universal courtesy.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
NB: as a Moderator, I never accept friendship requests.
Forum Rules (updated August 2023): please read them here.
For some reason, it doesn't work, maybe because formula is looking only at A1
I need to look and fill all cells with more then 3 characters in
It should and it does for me. See the attachment.
Excel 2016 (Windows) 32 bit
ttt tttt t tttt tttt tt ttt tttt ttt ttttt tttt ttt
Sheet: Sheet1
Does it make a difference if in cells I have Formulas ?
I mean t tttt... are result of formula in cells ...
Shouldn't do - attach a sample file so I can take a look.
Are we sorted?
not yet, for some reason, it doesn't work in my
I know it is simple but I have to see
As I said, please attach a sample workbook where it isn't working for you - I'll be able to troubleshoot it then.
Still waiting for your sample file. Can't really do anything more without it.
Sorry
Range is L4:W15
For example, LEN(L4)>2 but Conditional doesn't do it
You have inverted commas around the formula in the CF dialog. Remove them and it will work.
You need this:
=LEN(L4)>2
NOT this:
="LEN(L4)>2"
The inverted commas mean that Excel is looking for that text in the cell, not evaluating a LEN formula!
Last edited by AliGW; 01-20-2019 at 01:49 PM.
thank you, for solving fast
No worries - could have been much faster if you'd attached the file when I first asked for it!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks