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.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
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
A B C 1ttt tttt t 2tttt tttt tt 3ttt tttt ttt 4ttttt 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)
Bookmarks