Im having some problems with the conditional Formatting on one of my sheets and i can't figure out why.
Im using a very similar formula for it that I'm using on another sheet, but I can't get it to work properly. I should label every other row a different color, for some some reason some of the rows a remanning white.
The sheet in question is EquimentData.
Thank you for your time.
i am not able to find any rows that have data and remaining white in your sheet..
Regards
Fotis.
-This is my Greek whisper to Europe.
--Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.
Advanced Excel Techniques: http://excelxor.com/
--KISS(Keep it simple Stupid)
--Bring them back.
---See about Acropolis of Athens.
--Visit Greece.
Thats strange. On the EquipmentData sheet (not ReturnData) the following rows appear white for me:
4, 14, 226, 275, 410, 672, ….1694-1710...
That is because in your CF you have the part SUM(A14:D14)<>0. In row 14 for example there is no number, so the sum is null ( text does not count), and the formatting does not apply
In row 4 f.i. you have a text looking like a number in col B, so again the SUM (A4:D4) is null. Reentering 1002 manually solves the problem
Is there a different CF formula I could use that isn't specific to numbers, but rather just the presence of data (number of text)?
Try replacing SUM in your conditional formatting formulas with COUNTA
COUNTA counts text and numbers
Audere est facere
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks